The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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.
User | Count |
---|---|
86 | |
84 | |
34 | |
34 | |
33 |
User | Count |
---|---|
94 | |
79 | |
63 | |
55 | |
51 |