Removing 'K' from display unit in a table visual

[Anonymous]

Hello,

I can't seem to find a way to remove 'K' from display units and still keeping value in thousands in my table. I know I can create different measures or columns divided by 1000 or substitute K with anything, but I have already too many of those, I don't want to duplicate whole database (a lot of columns) to make those tables. Is that possible?

[praveenshenoy]

Its terrible that PowerBI cannot remove the K or M and is asking us to create a new measure. every such new measure makes the tables clunky and extremely busy with too many fields. So not solution, this is another reason we should not move to PowerBi.

[v-jiascu-msft]

Hi @Anonymous,

Can you change the format to achieve it? Please refer to the snapshot below.

Best Regards,
Dale

[Greg_Deckler]

So, does the original data have a K in it or is it numeric as in 10,000?

[Anonymous]

@Greg_Deckler Original data is numeric, '100200' for example

@v-jiascu-msft This is the formating that I'm using right now. I would like to keep it like it is, just to remove 'K' without duplicating every measure and column. The display units are currently thousands in the table visual

 

[v-jiascu-msft · Accepted solution]

Hi @Anonymous,

I would suggest you vote up this idea. There isn't such a feature for now.

Best Regards,
Dale

[Anonymous]

@v-jiascu-msft thanks