Forum Discussion

Genrique's avatar
Genrique
Frequent Visitor
1 year ago
Solved

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. ...
General Comment
  • v-karpurapud's avatar
    v-karpurapud
    1 year ago

    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!

pankajnamekar25's avatar
pankajnamekar25
Super User
1 year ago

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 | LinkedIn

If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.

Genrique's avatar
Genrique
Frequent Visitor
1 year ago

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.

  1. It would be great if Power BI allowed using a specific measure for the error bar labels.

  2. In general, it would be great if Power BI handled unit formatting better automatically, so we wouldn’t have to create specific measures.