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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
jonakl
New Member

Using multiple slicers with OR Condition

Hi, I have multiple slicers on a page. The default behaviour of the slicers is AND behaviour so the display will be the intersection of the slicer 1 conditions and slicer 2 conditions. That makes sense for most scenarios, but I have a situation where I need the slicer to operate independently and have OR type behaviour.


Is there a method to introduce this without changing the datamodel?


For example, if one slicer condition has 1m in sales, the 2nd slicer has 2m and the intersection of both has 500k, I’d need to show 3m as the result value.


There are a number of complex relationships setup on the main tables so restructuring the current data model is not an option. I have looked at and tested some solutions but they don’t fit my scenario, as amongst other things I have multiple other slicers on the page. (I just need 2 slicers in particular to use the OR conditions, the others are fine.)


Thanks,
J.

1 REPLY 1
tamerj1
Super User
Super User

Hi @jonakl 

I hope this would help

https://youtu.be/l5JX3G5Ntzk

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.