How to add an "OR" filter on the filter panel?

[Zack92]

Hello, 

I trying to add three filters to the filter panel, but they're currently being combined with an "AND" operator instead of an "OR." Is there a way I can add it as "OR"

Thank you so much 

[Anonymous]

HI @Zack92,

AFAIK, current power bi use 'AND' logic to link these different filter effects and you can't modify with these effects.
If you want to achieve custom filter effect, I'd like to suggest you use unconnected table as data source and write measure expression to check these conditions to return flag.

After these steps, you can use this on visual level filter to filter records based on these flag.

Regards,

Xiaoxin Sheng

[Zack92]

Thank you guys for the help

[vicky_ · Accepted solution]

Unfortunately, that isn't really an option with the filter panel. To implement the OR filter, you'll need to create measures and use the slicer visuals - here's a tutorial on how to achieve that: https://apexinsights.net/blog/or-xor-slicing