Display Unit logic

[AxBI]

Hey there,

I'm wondering if anyone has any input on how Power BI determines which unit to apply when "Display Units" is set to "Auto".  There are times when the Auto-selected unit seems innappropriate (even when there is great disparity in the values for different categories). 

For example, in the picture below.  The highest value is 257 million (mn) and the lowest is 25 thousand (k), yet Power BI sets the unit to billions.  I would assume that it would make more sense for the auto option to be millions or thousands.

My questions are:

1. What is the logic that Power BI uses to automatically determine the Display Unit?

2. Are there any ways to encourage a certain/better type of unit (bn,mn,k, etc) seclection while keeping it dynamic?

Thanks!

[danextian]

Hi @AxBI ,

Question1: I have no idea what's the logic behind.

Question2: You can certainly use DAX to create a custom unit label. Below is  a sample formula from another thread -

Custom Unit Label = 
VAR SafeLog =
    IFERROR ( ABS(INT ( LOG ( ABS ( [Total] ), 1000 ) )), 0 )
VAR dp = 1
RETURN
    ROUND ( DIVIDE ( [My Measure], 1000 ^ SafeLog ), dp )
        & SWITCH ( Safelog, 1, "K", 2, "M", 3, "bn", 4, "tn" )

https://community.fabric.microsoft.com/t5/Custom-Visuals-Ideas/Auto-Format-Numbers-in-Billions-Milli... 

Custom label tutorial - https://www.youtube.com/watch?v=J56xoO5tWhk