How to change the display unit of values in y-axis to hundereds

[Anonymous]

Hi

Is there any way to change the display units of Y-Axis to a hundred? As in the dropdown for display units, I can only see thousands, millions, or trillions only.

If anyone has any idea regarding then please comment.

Thanks

[v-yalanwu-msft]

Hi, @Anonymous ;

You could add a measure like below:

Measure = 
sum('Table'[Value])/100 & "hundered"
  

BTW, even if you change the display format, the result is also transformed to text.

Or You can submit a feature request in Power BI ideas forum.

https://ideas.powerbi.com/ideas/idea/?ideaid=ebe46bf1-b559-477d-9651-ecad6a614371

https://community.powerbi.com/t5/Desktop/Changing-the-display-units-of-a-kpi-indicator/m-p/496878

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[AnamPatel]

There is not any option available to Select Display Unit as Hundred. You can try to select Display Unit as None and set up the range manually under the Range Menu. You might have to do some trial and error but I believe you can get it done from here.