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,
I wanted to show one decimal point if the Sales value exceeds 10,000 for example 10.5K if it is less than 10,000 then it should value without decimal point for example 9023
I can't use Format function as that would convert the measure to Text and i can't use that text measure in bar chart.
Could you please help me on this ?
Thanks,
Shubham
@Anonymous , You can try like and set decimal format to auto
sumx(Table, if([sales]<10000, round([sales],0) , round([sales],2)))
But I doubt this will work because internally it might still have a fixed decimal places.
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 |
---|---|
113 | |
104 | |
77 | |
67 | |
63 |
User | Count |
---|---|
144 | |
107 | |
105 | |
82 | |
69 |