Need help in formatting thousand separator and decimal points using FORMAT()

[johnyip]

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.

[johnyip]

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.

[johnyip · Accepted solution]

I just found a twisted way to achieve this:

IF(INT([measure])=[measure)],FORMAT([measure],"#,##0"),FORMAT([measure],"#,##0.####"))

But I am really not sure if this is the best way to do that,as this seems stupid. Please tell me if there is a smarter way.