In this video, you'll learn how to incorporate a budget versus actual maintenance cost variance value into a time series clustered column chart in Power BI.
By explicitly showing the variance between the cost and the actual, you'll be able to quickly see the difference.
Normally you'd have to ...
... look at the budget
... then look at the actual values
... and then internally calculate the difference in your head (not always easy!)
That process takes time and more importantly 'cognitive load' making it a little bit harder and more effort to interpret the data.
Displaying the difference explicitly will speed up and simplify your charts and make it far simpler for the person reading the chart to interpret the data.
That's not all! To further improve the ease and speed of perception I'll then add an up-down arrow and some colour conditional formatting to the budget vs actual maintenance cost variance label. This will really make it really stand out in months when the cost is over the budget.
I've used budget vs actual cost, but this approach can be used whenever you are displaying multiple columns on a clustered column chart in Power BI.
Another couple of good use cases for this, from a maintenance work management point of view would be:
1.) Schedule attainment in a week - show the number of work order schedule vas the number completed. The variance will show the number not completed.
2.) Preventative Maintenance Compliance - show the number of PM work orders due for completion in the month vs the number actually completed in the month as columns, then use the variance label to show the number not completed.
----------------------------------
⏩ Video Navigation
----------------------------------
00:00 - Intro & why this is useful.
01:18 - Overview of the approach used
03:03 - Configuring the Dynamic Formatting DAX
05:35 - Adding the variance labels to the chart
07:30 - Add conditional formatting to the variance label
09:40 - Format the legend
-----------------------------------------------------
🎥 Related Videos
-----------------------------------------------------
A good guide explaining DAX FORMAT function
[ Ссылка ]
-----------------------------------------------------
🎓 Power BI Dashboard Training
-----------------------------------------------------
👉FREE Power BI Quick Start Course - Learn how to create your first dashboard in around 90 minutes!
[ Ссылка ]
👉 Power BI Quick Start PLUS - Learn how to craft KPI management dashboards that help you, your boss, and your peers make better decisions!
[ Ссылка ]
-------------------------
📁 Resources
-------------------------
👉Access to the source PBIX files for this YouTube video:
[ Ссылка ]
👉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).
[ Ссылка ]
