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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
geleigh
Frequent Visitor

How do I create a card based on conditional formatting?

Hi Everyone,

 

I'm looking to take this table I've conditionally formatted and have a card next to it that shows the number of projects that are in the red. Please let me know if this is possible?

 

geleigh_1-1636495809345.png

 

1 ACCEPTED SOLUTION
AlexisOlson
Super User
Super User

You can iterate over the projects and count which ones satisfy the rule for red.

 

Roughly like this:

SUMX ( VALUES ( Products[Product] ), IF ( [Hours Remaining] < 0, 1, 0 ) )

 

Modify the condition inside the IF to be whatever matches your rule for highlighting red.

View solution in original post

1 REPLY 1
AlexisOlson
Super User
Super User

You can iterate over the projects and count which ones satisfy the rule for red.

 

Roughly like this:

SUMX ( VALUES ( Products[Product] ), IF ( [Hours Remaining] < 0, 1, 0 ) )

 

Modify the condition inside the IF to be whatever matches your rule for highlighting red.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.