QT#88 - Dynamic Formatting Power BI Data Label Rounding Suffixes

In this video, you'll learn how to use dynamically format the rounding suffix of data labels, based on the value of the column.
So for example, if the value is greater than 1,000, it'll be displayed as 1K but if it is below 1,000, it'll just display the number with no rounding e.g. 56.
This approach simplifies data presentation by using appropriate rounding and suffixes, such as 'K' for thousands, making the chart data labels easier to understand at a glance.
----------------------------------
⏩ Video Navigation
----------------------------------
00:00 - Intro
00:47 - Dynamic Formatting Data Labels
02:10 - Adding the DAX code to the FORMAT area
03:48 - Setting Display Unit Options
04:34 - Issue with Y- Axis
-----------------------------------------------------
🎥 Related Videos
-----------------------------------------------------
A good guide explaining DAX FORMAT function
dax.guide/format/
-----------------------------------------------------
🎓 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 help you, your boss, and your peers make better decisions!
effectivedashboards.com/power...
-------------------------
📁 Resources
-------------------------
👉Access to the source PBIX files for this KZbin video:
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-...

[@zahir585]

Awesome tricks. thank you for your contributions. Love your channel ❤

[@jasondavidsondata]

So happy that you are enjoying the vids, and find them useful 😊 thanks for your kind comment

[@ramakumarguntamadugu1299]

very useful trick👌👌👍👍

[@jasondavidsondata]

Hi Ramakumar, thanks for all your kind comments...its much appreciated, and I super happy you are getting something out of my videos. 😀

[@akashchauthmal8559]

Its not working with live data connection. Can you please tell some workaround

[@user-me6kw9df8u]

Please format negative numbers also, I'm getting small brackets as well as -ve sign both. ex: -($12M) but i want only ($12M)

[@jasondavidsondata]

Hi, can you post the format function code you are using?