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

November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Difinity Conference

Difinity Conference 2022

Difinity is the largest Microsoft Data, AI, Power BI, Power Platform and Business Applications Conference in New Zealand.

European Share Point Conference

European Share Point Conference

This conference returns live and in-person in Copenhagen this 28 November-01 December with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.