Forum Discussion

vjnvinod's avatar
vjnvinod
Icon for Impactful Individual rankImpactful Individual
7 years ago
Solved

Display Unit Formatting without abbreviations (remove "K")

 

Hi Team,

 

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"

  • vjnvinod's avatar
    vjnvinod
    7 years ago

    v-yuta-msft 

     

    I have posted this as idea, can you please vote & socialise this with Develpoers, so that we have this available?

     

    Customize the "Display Units property in a visual." removal of abbreviations

4 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Icon for Community Support rankCommunity Support

    vjnvinod ,

     

    You can create a new column:

     

    New Column = Table[Number] / 1000

     

    Community Support Team _ Jimmy Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • vjnvinod's avatar
      vjnvinod
      Icon for Impactful Individual rankImpactful Individual

      v-yuta-msft 

       

      This doesn't help, but many thanks, this is something i already tried

      Currently using this  measue, i can change 167,000,000 to 167,000 and my when my end user extract the data in excel, he gets the number as 167,000

       

      But my clients requirment is that, when he extract the data's from visuals into excel, he should get 167,000,000

       

      as explained in my above thread

       

      • v-yuta-msft's avatar
        v-yuta-msft
        Icon for Community Support rankCommunity Support

        vjnvinod ,

         

        I'm afraid exported value will be same with the original value in power bi dataset. You may submit this idea here.

         

        Community Support Team _ Jimmy Tao

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.