Forum Discussion
Dynamic Formatting with 1000 Seperator not working
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.
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
Hi Anonymous ,
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.
6 Replies
speedrampsSuper User
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
Hi Anonymous ,
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.
- speedramps
Anonymous
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.