Forum Discussion
Dynamic display units
I want my data to show dynamically millions or thousands according to their values size(if value is too small,i want it in thousands or if value is big,i want it in millions)without any measure. Is t...
Anonymous , Usually when using Auto at a visual level it should Auto adjust. Otherwise you can write a logic
like
Switch(True(),
[Value]>1000000, format([Value]/1000000, "#,###M",
[Value]>1000, format([Value]/1000, "#,###K",
//add other
)