Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
emilyhch
Frequent Visitor

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 create this visual by changing the format code (attached below) but it's not showing that I am hoping to see. Both of these data are measures I created in Power BI. 

emilyhch_0-1706725676899.png

 

This is what I see right now: 

emilyhch_1-1706725707654.png

 

If I could let 30% go to where 00% currently is, that would be amazning.  Am I doing it right? Or is there another way to display the measures like 3 (30%) together in one visual? 

 

Thank you in advance for you help! 

 

Best,

Emily

 

1 ACCEPTED SOLUTION

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.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

View solution in original post

7 REPLIES 7
SM321
Frequent Visitor

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

SM321_0-1706727123877.png

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

SM321_1-1706727211486.png

 

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

edhans
Super User
Super User

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:

edhans_0-1706726273884.png

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

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

 

edhans_1-1706726405799.png

 



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

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!

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.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

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.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.