Value Display Unit AUTO - Power BI Automatically Set The Units Too High (e.g. I want 180k not 0.18M)

[Anonymous]

Hi all,

I am creating a visual with values that ranges from zero to millions depending on the applied filter. Thus, I have applied "Auto" in all settings for Y-axis and Data Labels. However, Power BI always decides to pick up the biggest available units when it would probably be more appropriate to select the lower one.

For example, in the image below Power BI decided to show the values in millions when it would have been more appropriate to show them in thousands instead:

Unfortunately, I cannot set "Thousands" in Display Units because these values can change radically depending on the applied filter. So, I want it to change dynamically but I would like Power BI to get smarter when chosing the units. In the example above, I would like to display 180k rather than 0.18M.

Does anyone know how can I achieve that?

Thank you!

Dodo

[amitchandak · Accepted solution]

@Anonymous , I remember in this video they show some way for custom label using calculation group- Just check description first

https://www.youtube.com/watch?v=IH4bcHhxunw