Forum Discussion
How to hide display units?
Hi,
I'm wondering how to make the value not show "k", only 25,956
Hi YunJ ,
We can use three ways to meet your requirement.
1. Create a measure to calculate the value / 1000.
value /1000 = CALCULATE(SUM('Table'[value]))/10002. Create a measure just show the text of K value.
value K = var x = FORMAT(CALCULATE(SUM('Table'[value])),"#-###") return LEFT(x,LEN(x)-4)3. We can create a new table and a slicer to control the units.
Slicer measure = var x = SELECTEDVALUE('Table (2)'[unit]) var sum__ = CALCULATE(SUM('Table'[value])) var y = CALCULATE(SUM('Table (2)'[Column1]),FILTER('Table (2)','Table (2)'[unit]=x)) return IF(x="K",sum__/y,sum__)BTW, pbix as attached.
Best regards,
Community Support Team _ zhenbw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
YunJ , Have measure /1000 or use the custom format string
https://docs.microsoft.com/en-us/power-bi/desktop-custom-format-strings
Hi, amitchandak
There is no Property pane under View. Also, under Modeling, there is no custom option for the format.
Hi YunJ ,
We can use three ways to meet your requirement.
1. Create a measure to calculate the value / 1000.
value /1000 = CALCULATE(SUM('Table'[value]))/10002. Create a measure just show the text of K value.
value K = var x = FORMAT(CALCULATE(SUM('Table'[value])),"#-###") return LEFT(x,LEN(x)-4)3. We can create a new table and a slicer to control the units.
Slicer measure = var x = SELECTEDVALUE('Table (2)'[unit]) var sum__ = CALCULATE(SUM('Table'[value])) var y = CALCULATE(SUM('Table (2)'[Column1]),FILTER('Table (2)','Table (2)'[unit]=x)) return IF(x="K",sum__/y,sum__)BTW, pbix as attached.
Best regards,
Community Support Team _ zhenbw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Seriously, no other display unit format solution?
