I want to know if it is possible to display data in thousands, but without the "K" at the end of the data. We know our reporting is in '000s, we just need the values and the K at the end creates unnecessary clutter.
Solved! Go to Solution.
Create a measure that equals the value e.g.
For another option, you could create a calculated column by SUBSTITUTE like below, then change the data type to be whole number.
Column = SUBSTITUTE('Table2'[value2],"K","")
The output is below.
That's not the ideal solution also due to rounding. I was using a /1000 measure and now I'm struggling with not correct results. Mathematically it doesn't make sense but I believe it's a limitation of Power BI.
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.