Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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]))/1000
2. 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.
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]))/1000
2. 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?
@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.
User | Count |
---|---|
126 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |