Forum Discussion

hobosapien's avatar
hobosapien
Helper I
2 years ago
Solved

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...
Need Help
  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    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

Ritaf1983's avatar
Ritaf1983
Super User
2 years ago

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