Comma separator in Card Visual not showing

[hobosapien]

I have the Display Units settings on Auto and not sure how to insert a comma separator for these amounts. The numbers are derived from a basic Measure and not sure if that has something to do with it?

[hobosapien]

Thanks - as always the simplest solution is usually the correct one. 

[Ritaf1983]

Yep and happy to help 🙂

[Ritaf1983 · Accepted solution]

Hi @hobosapien 
If you measure is a numeric data type, you need to format it from measure tools:

and in the card select none format on display units :

If the measure is text ( 4990 hours) , you need to use "Format" function :
Like :

Total sales text = Format([total_sales],"###,###") & " Dollar"

The pbix with the example is attached

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