Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi together
My target is to count cells based on the background color.
The background color is done via conditional formatting.
For the conditional formatting I have a measure:
Now I want to count the cells based on the background color.
I tried a few things but nothing worked for me.
Help is very appreciated and thanks in advance.
hi @eierkopf
what filter context do you have for the screenshot?
they have to be reflected in the count measure.
Hi @FreemanZ
Sorry here a better overview of the dashboard:
The count should be recounted everytime a filter changes.
Thank you.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
10 | |
9 | |
8 | |
8 | |
6 |
User | Count |
---|---|
14 | |
13 | |
11 | |
9 | |
9 |