cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Mo-PHAT Frequent Visitor
Frequent Visitor

Multiple OR filters

I have been asked to setup a report that will analyse multiple categories and give a result set with a ranking for how many of those categories a person meets.

 

The problem is multiple slicers act like AND's.  Anyone have any smart ideas how I could work a bunch of OR's??

 

Thanks in Advance Smiley Happy

1 ACCEPTED SOLUTION

Accepted Solutions
v-huizhn-msft Super Contributor
Super Contributor

Re: Multiple OR filters

Hi @Mo-PHAT,

>> The problem is multiple slicers act like AND's.  Anyone have any smart ideas how I could work a bunch of OR's??
When you create slicer from same table, the slicers act like AND, they influence each other. You can change the relation between them as follows.

Please click the slicer, under Format, Click “Edit Interactions”, you will see funnel(highlighted in yellow background) and circle(highlighted in red line) in other slicers. When you select the funnel, it means the log slicer can be affected by user slicer. Otherwise, if you select the circle, it is not effected by the use slicer. So you can create OR relationship between multiple slicer using funnel and circle bar.

1.png
 
If you have any other issue, please feel free to ask.

Best Regards,
Angelia

2 REPLIES 2
v-huizhn-msft Super Contributor
Super Contributor

Re: Multiple OR filters

Hi @Mo-PHAT,

>> The problem is multiple slicers act like AND's.  Anyone have any smart ideas how I could work a bunch of OR's??
When you create slicer from same table, the slicers act like AND, they influence each other. You can change the relation between them as follows.

Please click the slicer, under Format, Click “Edit Interactions”, you will see funnel(highlighted in yellow background) and circle(highlighted in red line) in other slicers. When you select the funnel, it means the log slicer can be affected by user slicer. Otherwise, if you select the circle, it is not effected by the use slicer. So you can create OR relationship between multiple slicer using funnel and circle bar.

1.png
 
If you have any other issue, please feel free to ask.

Best Regards,
Angelia

Mo-PHAT Frequent Visitor
Frequent Visitor

Re: Multiple OR filters

I thought you had figured it out but alas no this does not work