automatically switch to M or K - Table

[edubcardoso]

Hello everyone!

Maybe this is just a stupid question, but i cant figure it out.

I know in the Card view, we can set Auto in Display Units | Callout Value

But in Table view that option doesnt exist to me. It's because of the data format/type ?

I want the cell value to switch from K to M ( or M to K ) when the slicers are applied, in the same column.

Value	What i want
40.000.000	40M
40.000	40k

Thanks

[amitchandak · Accepted solution]

@edubcardoso , Try something like,

SWITCH ( TRUE() ,
[Value] >= 1000000000 , CONCATENATE("$", FORMAT ([M1]/1000000000, "#,###.0") & "bn") ,
[Value] >= 1000000, CONCATENATE("$", FORMAT (COALESCE([M1], 0)/1000000, "#,###.0" )& "M") ,
[Value] >= 1000, CONCATENATE("$", FORMAT (COALESCE([M1], 0)/1000000, "#,###.0" )& "K") ,
CONCATENATE("$", FORMAT (COALESCE([M1], 0) , "#,###.0")
))