Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hello all,
I tried to use a DAX like FORMAT([a measure],"#,###.####") to control the display of a measure value as having a thousand separator and 4 decimal places.
This DAX is working fine except when the measure is actually an integer, an unnecessary trailing dot appears, as the follow picture.
I would be grateful if anyone can provide a DAX expression that can elminiate that trailing dot but retaining the setting of 4 decimal places and thousand separator. Thanks.
Solved! Go to Solution.
I just found a twisted way to achieve this:
I see there are no further replies, and I assume my twisted way is the only way to achieve my desired outcome under the current version og PowerBI.
I just found a twisted way to achieve this:
User | Count |
---|---|
141 | |
70 | |
70 | |
53 | |
53 |
User | Count |
---|---|
208 | |
95 | |
64 | |
61 | |
57 |