QT#72- Improve the Readability of YTD Actual Cost vs Budget Measure Using Power BI FORMAT function
In this video, you'll learn a quick and easy approach to improving the readability of measures. It is useful when showing a measure that calculates a variance from a baseline figure. For example percentage difference of YTD maintenance cost from the YTD maintenance budget figure.
If the cost is under i.e. cost is -2.34% below the budget, then it's easy enough to read because we instinctively read the minus sign and think "below".
However, if the actual cost is above the budget figure by 3.25% we don't automatically read this as being plus 3.25%. We tend to read it as being 3.25% of a figure and it means we had to stop and think about what the figure actually represents.
I'll explain how to add a '+' sign to the measure using the FORMAT function so it is displayed as +3.25%. It's a simple subtle change but makes a big difference. When we see the plus sign before the figure it's easier for us to read the actual cost as being 'plus' 3.25% over the budget cost.
----------------------------------
⏩ Video Navigation
----------------------------------
00:00 - Introduction
01:00 - Improving the title
02:35 - Improving the figure displayed
03:20 - Using FORMAT Power BI Function
05:40 - Summary of solution
----------------------------------
🔗Links
----------------------------------
FORMAT function format parameters explained.
https://learn.microsoft.com/en-us/dax...
-----------------------------------------------------
🎓 Power BI Dashboard Training
-----------------------------------------------------
👉FREE Power BI Quick Start Course - Learn how to create your first dashboard in around 90 minutes!
https://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!
https://effectivedashboards.com/power...
-------------------------
📁 Resources
-------------------------
👉Access to the source PBIX files for my YouTube videos:
https://effectivedashboards.com/course/
👉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).
https://effectivedashboards.com/data-...