cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
piaco New Member
New Member

Count the number of cells with a specific color (conditional formatting)

Hi, I have a table with a column where I have applied conditional formatting if the value is above a certain number. Now I want to count the number of cells with that specific color in a card visual, but I have no clue how to do that. Hope someone can give me a hand 🙂

2 REPLIES 2
HotChilli New Contributor
New Contributor

Re: Count the number of cells with a specific color (conditional formatting)

I think you'll have to write a measure to do the same thing as you're doing with a visual filter i.e. count the values above your threshold, and put that on the card

Community Support Team
Community Support Team

Re: Count the number of cells with a specific color (conditional formatting)

HI @piaco,

 

AFAIK, conditional formatting feature only available on table and matrix visuals.


In my opinion, I'd like to suggest you write measure to show symbol instead conditional formatting.

Power BI Desktop/DAX – Using Unicode (Arrows) as Measures in a Table


Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (2,006)