Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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
Solved! Go to 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
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
Thank you guys for the help
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