Power BI WATERFALL CHART Pt2 - How to EXPLAIN the records that make up the NET change in a category

In this video, number 2 in the mini-course on Power BI WATERFALL CHARTS, I'll talk you through how you can explain and display records which have contributed to the NET CHANGE in a category value between the start and end periods displayed in the waterfall chart.
With a waterfall chart, a question that is often asked is:
❓"If the number of records increased by X over the week, show me what those X records are?"
This can seem like a sensible question at first until you realise it can't actually be answered! I'll explain why it can't be answered and also show you how to answer the question that is really being asked!
Again we will use a waterfall chart that displays the change in maintenance work orders in the backlog by each department over a week.
Links to other videos in the series.
Power BI Waterfall Chart Pt1 - Format options, breakdown different between 2 dates and pros and cons.
• Power BI Waterfall Cha...
Power BI WATERFALL CHART Pt3 - Displaying the Records that Contribute to the Change Over the Periods
• Power BI WATERFALL CHA...
-----------------------------------------------------
🎓 Power BI Dashboard Training
-----------------------------------------------------
👉FREE Power BI Quick Start Course - Learn how to create your first dashboard in around 90 minutes!
effectivedashboards.com/power...
👉 Power BI Quick Start PLUS - Learn how to craft KPI management dashboards that really do help you, your boss, and your peers make better decisions!
effectivedashboards.com/power...
-------------------------
Resources
-------------------------
👉Access to the source PBIX files
effectivedashboards.com/cours...
👉Article series on creating a maintenance management system data model and how to address the human factors of data collection for improved data quality. (This is not just relevant to maintenance and reliability data).
effectivedashboards.com/data-...

[@cindypayet281]

Thank you for the great explanation, it is explained simply and really helped me to understand the mechanics. Have a nice day!

[@jasondavidsondata]

Hi Cindy, thanks for the kind comment and l'm glad you found it useful 👍

[@user-ub8zg8je9h]

How to hide categories with 0?