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

[Anonymous]

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 🙂

[v-shex-msft]

HI @Anonymous,

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

[HotChilli]

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