Forum Discussion

AxBI's avatar
AxBI
Regular Visitor
2 years ago

Display Unit logic

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 innappropr...
Need Help
danextian's avatar
danextian
Super User
2 years ago

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-Millions-Thousands-etc/idi-p/1439322 

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