Filtering issue

[Anonymous]

Hello All, 

  I am working with an Excel file that doesent have the info required clearly in a column. I have to take the data from a work order column and Advanced filter the First the letters to try and mimic the manual report that is created. So at the moment i have broken down the visuals in to over 13 Matrix boards (Every work order variation) and the advanced filter option would not work for more then one filter. EX: Advanced filter: Contains: "TER". (This works no problem). If i want to do Contains : TER / (and/or) Contains: WQC2 , it does not pop up with any data. Like mentioned, I have 13 visuals and in the manual report they have these categorized into 4 sections. 

I have attached some screenshots, please let me know!

Best,

Daniel 

[Anonymous · Accepted solution]

Hi @Anonymous,
According to your description, your filter branch only filters one visualization and does not work if there are two or more visualizations. This may be due to the fact that the scope of your filter is limited to only one filter.Power BI provides three scopes of filters, Visualization level, Page level and Report level. If your visualizations are on the same page, you can use the Page level filter. If your visualizations are on different pages, you can use the Report level filter.
Please note that these filters will still affect the data that matches this field on other visualizations, so you need to make sure that the other visualizations do not contain this field in order for the report to be complete.
add-a-filter-to-an-entire-page 
add-a-report-level-filter-for-an-entire-report 
Types of filters in Power BI reports - Power BI | Microsoft Learn

Best regards,
Albert He

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