Showing results for 
Search instead for 
Did you mean: 
New Member

Filter for Rows based on Fill Colour in Power BI Report Builder

Hi there!


New to the community, and a complete newbie when it comes to building BI Reports. 


Some pre-amble... We build our reports in Power BI Report Builder, and within those reports we apply conditional formatting to fill the cell with a noticable colour when some client specific requirement/flag is hit to highlight it to our internal admin team. This I've gotten down. 

The problem is that our admin team like what they refer to as an "exception report" where it's basically the same report, but only shows items which have hit those flags.

What I'd like to know, is it possible to build a filter in order to filter out rows which don't contain any non "trasparent" filled rows? I've seen that various predecessors where I work have achieved this several different ways, the most common being a duplicate report. But this problem definitely feels like it could be solved with an expression? 


Thank you for your time and any suggestions you may have! 









Community Support
Community Support

Hi @Alex_Auld ,


According to your description, you can filter the corresponding rows by setting the parameters.

For more details, you can read below document:

Report parameters in Power BI Report Builder - Power BI | Microsoft Docs

If the problem is still not resolved, please provide detailed error information and test data. Looking forward to your reply.

Best Regards,

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors