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 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.

  • 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

2 Replies

  • ricardocamargos's avatar
    ricardocamargos
    Icon for Continued Contributor rankContinued Contributor

    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
      Icon for Impactful Individual rankImpactful Individual

      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"