Webinar recording
Mastering Variance Reports in Power BI

In this webinar, we will analyze and explain the most effective methods for presenting variances in Power BI dashboards and reports.

What's included

Full video recording
PBIX example used in the webinar
Enjoy & thank you for watching! Don't hesitate to reach out if you have any questions — write to us at support@zebrabi.com!

Presenter

Andrej Lapajne

Founder & CEO at Zebra BI

Watch the Video

Get PBIX Example
You can download the PBIX example that we used at the webinar to check how it's done!
Access the materials
(1:18) Example of a dashboard in Power BI
(3:28) Including forecast data in reports
(4:55) Presenting more data in detail: Multiple charts
(7:04) Hierarchical display of data
(8:27) Income statement example
(11:27) Recap of how to use Zebra BI visuals in Powe BI
(14:32) Use of variance charts
(15:52) Showing the comparison in the chart
(17:19) Sorting
(17:39) Displaying the grand total
(19:07) Adding the region
(19:45) Group vs. category field: Chart type
(20:34) The positioning of the grand total
(21:48) Switching between different type of charts
(24:44) Editing style
(26:20) building the hierarchy
(28:02) YTD – Year to date
(28:51) Adding a period calculation
(30:05) Managing Slicers
(31:24) Presenting YTD
(32:12) Editing the opacity
(32:39) Adding Forecasts
(35:40) Switching visibility of charts: Bookmarks
(37:46) Inverting colors - basic
(38:44) Creatin Income statement
(38:58) Preparing the data
(39:43) Creating the hierarchical chart
(40:42) Turning off the sorting
(41:08) Inverting the colors and specifying the results in Income statement
(43:15) Managing comparisons
(44:26) Zebra BI resources
(45:31) Q & A
Share this

Ready to start uncovering actionable insights from your data?

Explore Zebra BI for Office and Power BI, or start a trial instantly and test our tools on your data. You can also contact us to help you build your first test report and create a custom package for your business.

More Trending Webinars

Upcoming
July 10, 2025
Future-Proof Financial Reporting: Automate, Standardize, and Scale with Power BI
Learn how to automate and standardize P&L, BS & CF reports in Power BI with Zebra BI — no copy-paste, broken links, or inconsistent KPIs.
Register
May 28, 2025
Beyond Excel: How Modern CFOs Leverage Power BI and AI for Better Insights
Modern CFOs are moving beyond spreadsheets to lead with data. In this webinar, you’ll learn how Power BI and AI are transforming financial reporting—turning static numbers into strategic insights.
Watch now
April 16, 2025
Power BI Made Easy – 5 Steps to Actionable Reports
We’ll show you how to reduce complexity and create reports that provide immediate insights— without in-depth Power BI knowledge.
Watch now
November 27, 2024
The New Era of Business Intelligence: AI-Powered Business Decision-Making
Artificial Intelligence is transforming Business Intelligence and data analysis, offering powerful tools for data-driven decision-making. But where does AI fall short, and how can we bridge these gaps to maximize its potential?
Watch now
December 5, 2024
How to Make Power BI Dashboards Actionable and Drive Better Decisions 
Power BI can be a true game-changer for organizations looking to turn their data into actionable insights. But how do you leverage it to achieve its max potential -- and how do you make handling dashboards easier, more user-friendly, and more efficient? Join our FREE webinar and find out!
Watch now
Browse All Resources