Rules for "Auto" Display Units?

[Anonymous]

Hi there!

I'm a bit confused by the rules for setting you Display Units in bar charts to "Auto". We use the same dashboard for many different clients, some of which are huge, and some are quite small, so the Auto Display units seems like a good solution. However, it seems to behave strangely when you want to display data in the hundreds of thousands. See here (and don't mind the (Blank), lol :D):

Does anyone have any insight as to the rules that are followed when you set your display inits to "auto"? Thanks!

Jaap

[Jim_B]

I'm having challenges with the auto approach.  An improvement would be to enable the auto algorithm with selected display units or a maximum/minimum display unit.  Another BI tool I've worked with has this feature.  For example, I want auto display units but I never want to see the data in billions or trillions, only in thousands or millions.  

[abudde]

Hi Jim, 
did you found a solution for your auto unit approach?
I would like to block as well teh billions, all other units are ok. 

best regards

[v-shex-msft]

HI @Anonymous ,

It seems like your records value are too small to display on million unit, you can modify decimal place to display them more clearly.

Regards,

Xiaoxin Sheng

[Anonymous]

ough that would help in this case, we have other clients where these numbers might be in the hundreds, causing the data to show 100.0, which of course we'd like to avoid.

I would just want to know what rules PowerBI applies. When does it flip from showing 100K to 0M?

[Anonymous · Accepted solution]

I think I just figured it out.

The "Auto" labels actually listens to the Y axis of your graph. If your Y axis is being displayed in Thousands, your labels will also be displayed in thousands. The nasty thing is that the smaller the Y axis is, the more likely it is to choose a higher divider (So M instead of K). I dont understand the reasoning behind this, but sadly, this is just how it is for now.