Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 🙂
Solved! Go to Solution.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |