Forum Discussion
Using Card (New) visual to display two data points
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.
Understood. Thank you!
Yes I was able to get (30%) using the format but I was wondering, because I want to show the actual numbers and percentage side-by-side at the same time, is there a format or even dex to do so if I don't use the card viz?
For example, if there were 3 requests in progress (10 requests in total), I would see 3 (30%). If there were 2 requests in progress (15 requests in total), I would see 2 (13%). The total number of requests is a measure counting the number of request IDs.
Hope that explains what I am trying to visuzalize. Thank you very much.
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.