Forum Discussion
Handling unit scale in charts
Power BI is a wonderful program — what you can do once you dive a bit deeper into it is incredible. Even so, there are things I don’t understand how, after so many years, still haven’t been changed.
In my opinion, the automatic use of units in charts is one of them. As you can see, it automatically uses billions instead of millions, resulting in labels that lack useful information. I know the quick fix is to set the units manually to millions, but when the chart is filtered, I would run into the problem of using millions when units would actually be more appropriate.
In some cases, I’ve solved this using DAX with custom formats, and I’ll do the same for the total labels. The problem lies in the error labels, where I’m not allowed to add a measure that specifies the unit format through DAX.
hope this post helps bring visibility to this issue and reaches the Power BI development team. Thank you!
Hi Genrique
Thank you for reaching out to the Microsoft Fabric Community Forum.
Thank you HarishKM and pankajnamekar25 for your quick response.
We understand your concern regarding Power BI’s automatic unit scaling in visuals. While it can be useful, it may lead to confusing outputs, especially with dynamic datasets or filters.
Regarding your specific point about error bar labels:
Currently, Power BI does not support dynamic unit adjustment for error bar labels through a measure. Unlike data labels, where a DAX measure using FORMAT() can create custom units, this flexibility is not available for error bar annotations. The only workaround is to manually set the units in the axis or data label formatting settings. However, this does not dynamically respond to changing filters or data volumes.
As this is a product limitation, we highly encourage you to submit your feedback to the Power BI Ideas forumFabric Ideas - Microsoft Fabric Community. The Ideas platform significantly influences future feature development, and more feedback increases the likelihood of prioritizing this functionality in future updates.
If my response has resolved your query, please mark it as the Accepted Solution to assist others. Additionally, a 'Kudos' would be appreciated if you found my response helpful.
Thank You!
5 Replies
Hi Genrique
Thank you for reaching out to the Microsoft Fabric Community Forum.
Thank you HarishKM and pankajnamekar25 for your quick response.
We understand your concern regarding Power BI’s automatic unit scaling in visuals. While it can be useful, it may lead to confusing outputs, especially with dynamic datasets or filters.
Regarding your specific point about error bar labels:
Currently, Power BI does not support dynamic unit adjustment for error bar labels through a measure. Unlike data labels, where a DAX measure using FORMAT() can create custom units, this flexibility is not available for error bar annotations. The only workaround is to manually set the units in the axis or data label formatting settings. However, this does not dynamically respond to changing filters or data volumes.
As this is a product limitation, we highly encourage you to submit your feedback to the Power BI Ideas forumFabric Ideas - Microsoft Fabric Community. The Ideas platform significantly influences future feature development, and more feedback increases the likelihood of prioritizing this functionality in future updates.
If my response has resolved your query, please mark it as the Accepted Solution to assist others. Additionally, a 'Kudos' would be appreciated if you found my response helpful.
Thank You!
Hello Genrique
By default it is not possible , but you can crate a dynamic formatting measure and add that into as data label
Formatted Sales =
VAR SalesValue = SUM(Sales[Amount])
RETURN
SWITCH(
TRUE(),
SalesValue >= 1000000000, FORMAT(SalesValue / 1000000000, "0.00") & " B",
SalesValue >= 1000000, FORMAT(SalesValue / 1000000, "0.00") & " M",
SalesValue >= 1000, FORMAT(SalesValue / 1000, "0.00") & " K",
FORMAT(SalesValue, "0.00")
)
Thanks,
Pankaj Namekar | LinkedInIf this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.
Thanks for the help, I probably didn’t explain myself well. I know how to do it with DAX and that’s how I solved the bar labels. The problem is with the error labels, which don’t allow the use of the FORMAT function in the measure, since the label doesn’t support using a specific measure.
It would be great if Power BI allowed using a specific measure for the error bar labels.
In general, it would be great if Power BI handled unit formatting better automatically, so we wouldn’t have to create specific measures.
Genrique Hey,
you can write dax to automatically format unit string.I will suggest Kindly refer this blog post - Power BI - Change display unit based on values in table - Power BI Docs
Thanks
Harish M
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your queryThanks for the help, I probably didn’t explain myself well. I know how to do it with DAX and that’s how I solved the bar labels. The problem is with the error labels, which don’t allow the use of the FORMAT function in the measure, since the label doesn’t support using a specific measure.
It would be great if Power BI allowed using a specific measure for the error bar labels.
In general, it would be great if Power BI handled unit formatting better automatically, so we wouldn’t have to create specific measures.
