Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Using Card (New) visual to display two data points

Hi there,    I am trying to use the new Card visual to visualize two measures together in my dashboard - Number of TTA request in progress, % of TTA in progress (e.g. 3, 30%)     I tried to creat...
Need Help
Tips and Tricks
  • edhans's avatar
    edhans
    2 years ago

    Those need to be separate values, and you add them using the Reference Labels or Details. 

    If you want them as one string, you could use the FORMAT function. Example:

    FORMAT([The Measure], "#.0%") & " " & FORMAT([The Measure], "(#.0%")

     

    That would add the same measure formatted two ways. You cannot format one measure with a string two different ways and get it to show twice. The FORMAT() function will let you be as detailed as you like and allow you to repeat the same thing different ways.

SM321's avatar
SM321
Frequent Visitor
2 years ago

Did you try using reference labels? You can try something similar and play around with formating to get what you would like. 

Would show something as below in the same card. You might have to create measures depending on your scenario.

 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Thank you SM321 . I need the % to be shown in parentheses after the number but this is a good idea I can use in the futre. Thanks