Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
barakm
Frequent Visitor

Using more than 2 filters best practice

Dear all, 

What would be the best practice to add more than 2 filters available in the filtering tab ? 

For example:

I have a table visual and I wish to show all values that not contains  "A" or "B" or "C" or "D"  

looking at the filtering tab, I see that I can only use "A" or "B"   

Thank you

Barak

1 ACCEPTED SOLUTION

Hi @barakm 

 

You can add the same field to the filter pane multiple times. Depending on what behavior you want the filters to have, this may or may not work for your use case:

 

dk_dk_0-1722429734632.png

 

An alternative would be to add a calculated column (DAX or in Power Query) that checks for all the conditions you want, and returns True or False for each row in your data. Then you can use this calculated column as a filter. Here is how that would look like using DAX calculated columns:

dk_dk_1-1722430288525.png


in the if statement, || is the OR operator, && is the AND operator, and CONTAINSSTRING evaluates to True or False for each criteria.


I guess it might work as a measure as well, similar to SamWiseOwl's solution.

I hope this helps!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





View solution in original post

3 REPLIES 3
barakm
Frequent Visitor

Hi SamWiseOwl...

Thank you very much for your reply, this is nice perspective to do it 

I tried this, and it worked but for exact match.

How do I change this for somthing that only contains these attributes ?

for example if I do  "A" or "B" or "C" or "D"   I wish it would match also values like "bananA" or "Dongle" or "sCaner" 

Hi @barakm 

 

You can add the same field to the filter pane multiple times. Depending on what behavior you want the filters to have, this may or may not work for your use case:

 

dk_dk_0-1722429734632.png

 

An alternative would be to add a calculated column (DAX or in Power Query) that checks for all the conditions you want, and returns True or False for each row in your data. Then you can use this calculated column as a filter. Here is how that would look like using DAX calculated columns:

dk_dk_1-1722430288525.png


in the if statement, || is the OR operator, && is the AND operator, and CONTAINSSTRING evaluates to True or False for each criteria.


I guess it might work as a measure as well, similar to SamWiseOwl's solution.

I hope this helps!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





SamWiseOwl
Super User
Super User

Hi @barakm 

One way of doing this is creating a Measure that defines what to keep and what not.
Then use this as a filter on your measure:

SamWiseOwl_0-1722411762817.png

If this helps please mark as a solution for others to find 🙂
Let me know how you get on!


If you are happy with this answer please mark as a solution for others to find !

Kudos are always appreciated! Check out our free Power BI video courses.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.