March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Register NowGet certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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?
Solved! Go to Solution.
Hi @Anonymous,
I would suggest you vote up this idea. There isn't such a feature for now.
Best Regards,
Dale
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.
So, does the original data have a K in it or is it numeric as in 10,000?
@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
Hi @Anonymous,
I would suggest you vote up this idea. There isn't such a feature for now.
Best Regards,
Dale
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Check out the November 2024 Power BI update to learn about new features.
User | Count |
---|---|
53 | |
41 | |
37 | |
30 | |
21 |