Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Team,
Once we select Display unit as Thousands or Millions and other format. It bydefalt show "K" or "M" as per the unit.
But is there a way we can remove this "K" or "M" from the number and it should be in Thousands or Millions according to display unit selection.
Manish
Solved! Go to Solution.
hi, @manishbeniwal
If you could use a measure to get it.
for example:
Create a measure with conditional divide 1000, then use this measure
Measure (Number in Thousands) = CALCULATE(SUM(Table1[Value]))/1000
Result:
Best Regards,
Lin
Hi,
Your question is not clear. What exact result are you expecting?
Once i select display unit "Thousand" then in my table i don't want to show "K" but the number unit should be in thousand conversion.
Regards
Try setting the "Display Unit" to "None". Then select the Field on the right-hand side, select "Modeling" at the top and change the decimal precision out to the number of places needed.
I want that number in table should be converted in unit like 27958 should comes as 28 not 28K after changing the display unit to "Thousands". I dont want to show "K" or "M" after display unit change.
and then i will chagne the number column heading (Number in Thousands) for reference.
Thanks
hi, @manishbeniwal
If you could use a measure to get it.
for example:
Create a measure with conditional divide 1000, then use this measure
Measure (Number in Thousands) = CALCULATE(SUM(Table1[Value]))/1000
Result:
Best Regards,
Lin
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |