Forum Discussion
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.
If you have any other issue, please feel free to ask.Best Regards,
Angelia
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.
If you have any other issue, please feel free to ask.
Best Regards,
Angelia
I thought you had figured it out but alas no this does not work
