Showing results for 
Search instead for 
Did you mean: 
Post Patron
Post Patron

FINDING: workaround to add more than 2 "Contains" in Filters

Hi there,


Not sure if this has been found yet, I see some asked this question and I also want to:

add more than 2 "contains" in Filters.



I just found a workaround and I'd like to share with you, attach the sample file for your verify the data in page. (I validated some, which seems correct). Download the file here.

Here is how to: let's say you want to add 5 "contains" in filter:

1. Drag and drop the field.

2. in "Basic Filtering" choose any 5 items

3. switch to "Advance Filtering"

4. change the criteria


See following GIF:



Thanks for everyone for your contribution in the past.


Super User
Super User

@h_l , Thanks for sharing.

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin
Want To Learn Power BI
Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!

Thank you too, @amitchandak , for your always kind help.

Helpful resources

2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Top Solution Authors