Display Unit Formatting without abbreviations (remove "K")

[vjnvinod]

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"

[v-yuta-msft]

@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]

@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]

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

[vjnvinod · Accepted solution]

@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