Forum Discussion

edubcardoso's avatar
edubcardoso
Advocate I
3 years ago
Solved

automatically switch to M or K - Table

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.

 

ValueWhat i want
40.000.00040M
40.00040k

 

Thanks

Need Help
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    3 years ago

    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")
    ))

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    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")
    ))