Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Removing 'K' from display unit in a table visual

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?

1 ACCEPTED SOLUTION

Hi @Anonymous,

 

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

 

Best Regards,
Dale

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

View solution in original post

6 REPLIES 6
praveenshenoy
New Member

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

Hi @Anonymous,

 

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

Removing-K-from-display-unit-in-a-table-visual

 

Best Regards,
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Greg_Deckler
Super User
Super User

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


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

@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

 2018-12-21 08_11_19-GSS REM Financial Report v1.1 - Power BI Desktop.png2018-12-21 08_11_40-GSS REM Financial Report v1.1 - Power BI Desktop.png

Hi @Anonymous,

 

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

 

Best Regards,
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

@v-jiascu-msft thanks

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors