Dynamic Formatting with 1000 Seperator not working

[MohanV125286]

Hello All,

I have a measure which i need to show in 1000 seperators.

I have multiple options but none of them have given me the right results.

Like, i have used custom format as "$#,0" under properties of a measure in model view.

But it is showing can't convert number to text,
I have tried in Data Modeling still throwing the same error.

[speedramps · Accepted solution]

Method1 - click on the thousand comma

Method 2 - set the thousand sepperator

Method3 - use DAX

Amount 3 = 
FORMAT(
SUM(yourdata[Amount3]),
"$#,0"
)

Please click the [accept as solution] and the thumbs up button. Thank you

[MohanV125286]

If I have added format (

"Total Company" ,FORMAT([Total Company sales TY$],"$#,0"),

) i am getting an error.

[speedramps]

@MohanV125286 

Please read the 3 methods I provided earlier, and follow those instructions exactly.

Your method does not work because it is using a text [measure] instead of a numberic column.

Total Company = 

FORMAT([Total Company sales TY$],"$#,0")

• The measure has already been formated at text. That is why you get the can't convert text to numeric error.

Just follow 3 methods I provided more carefully. They will always work. If you get an error then read the error and try fix it.

[MohanV125286]

I have tried this but i still can't get the solution

[Anonymous · Accepted solution]

Hi @MohanV125286 ,

I couldn't agree more with MohanV125286.

But I noticed you mentioned “it is showing can't convert number to text”, I think you need to make sure your Measure is presenting the full number type.

You can also look at this document: Use custom format strings in Power BI Desktop - Power BI | Microsoft Learn

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[MohanV125286]

I have tried this but i still can't get the solution

[speedramps · Accepted solution]

Method1 - click on the thousand comma

Method 2 - set the thousand sepperator

Method3 - use DAX

Amount 3 = 
FORMAT(
SUM(yourdata[Amount3]),
"$#,0"
)

Please click the [accept as solution] and the thumbs up button. Thank you