Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
78 | |
63 | |
52 | |
47 |
User | Count |
---|---|
212 | |
82 | |
61 | |
60 | |
58 |