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?

Hi Anonymous, I would suggest you vote up this idea. There isn't such a feature for now. Best Regards,Dale

Removing 'K' from display unit in a table visual

Greg_Deckler
Community Champion
7 years ago
So, does the original data have a K in it or is it numeric as in 10,000?
- Anonymous
  Not applicable
  7 years ago
  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
    Microsoft Employee
    7 years ago
    Hi Anonymous,
    
    I would suggest you vote up this idea. There isn't such a feature for now.
    
    Best Regards,
    Dale
v-jiascu-msft
Microsoft Employee
7 years ago
Hi Anonymous,

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

Best Regards,
Dale
Anonymous
Not applicable
3 years ago
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.