Forum Discussion
Comma separator in Card Visual not showing
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?
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
3 Replies
Thanks - as always the simplest solution is usually the correct one.
Yep and happy to help 🙂
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
