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.

edhans's avatar
edhans
Community Champion
2 years ago

Are you on the December 2023 desktop - the latest that was released in late January? I don't even see a format code for the new card. This is what I see:

That said, you should format your measure to be the format you want.

"#,0%;(#,0%);#,0%"

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Thank you edhans! I think I am on September 2023 version but I'm having trouble updating to a newer verison currently. 

     

    Using the older version, I could see (30%) but is there a way to also see the count in the front? showing 3 (30%) instead. 

    Thank you!

    • edhans's avatar
      edhans
      Community Champion
      2 years ago

      I would use the format method I showed for the measure and not what is in the card viz. If you are on Sept and seeing that it looks like that has been removed from December, which makes sense, formats should belong to measures, or be dynamic within the measure.

      That said, the format string I put above should work wherever format strings are available, and it turned the -0.3 in my data to the (30%) format you wanted.

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        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.