Forum Discussion

KSFellows's avatar
KSFellows
New Member
8 years ago
Solved

Display Units Abbreviations

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 n...
  • ricardocamargos's avatar
    ricardocamargos
    8 years ago

    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

ricardocamargos's avatar
ricardocamargos
Continued Contributor
8 years ago

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's avatar
vjnvinod
Impactful Individual
7 years ago

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"