Display Units Abbreviations

[KSFellows]

In visuals, we can use Display Units to add/format number or currency abbreviation.  For example Thousands ("K"), Millions ("M"), Billions ("B"). In some language or culture these abbreviations are not suitable. Instead of (K, M, B) we may want to display (M, MM, MMM) or (M, Mn, Md) or (K, M, G). It will be great to have customization of visual Display Unit abbreviations.

[ricardocamargos · Accepted solution]

Hi @KSFellows,

I`m not sure if you can do it, however you can create a custom column or title to use your new abbreviations. Also you can create a measure to calculate your values based on those abbreviations.

Ricardo

[vjnvinod]

@ricardocamargos @KSFellows 

How to create that custom coloumn?

my number is

167000000

i would like to see this as display unit as

167,000

how do i do this,?

also wanted to make sure that when my user extracts the data, he should get 167000000

Currently using the data label, i can change this 167,000K and my when my end user extract the data in excel, he gets the number 167000000

which he is fine with that, however, he doesn't want to see abbreviations like "K"