Forum Discussion
Display rows excluded by a slicer
Community ChampionHi JLOV75
You can use Edit Interactions to achieve this without the use of code.
All you need to do is click on the Slicer, then go up to Format in the ribbon. On the far left in the Format tab, you will see Edit Interactions. Click it.
Once you have done that, you can then go to the chart that you want to ignore the Sliver and click the "don't filter" button.
This will hopefully achieve what you're after.
If you want to actually use code, you can use REMOVEFILTERS to achieve this. Here is a link to another post that can provide a bit of additional insight: https://community.powerbi.com/t5/Desktop/Ignore-slicer-in-measure/td-p/1129414
All the best!
Theo
Thanks, however, that will give me a complete list of all items which isn't what I want. I need a table that displays the items filtered (included) by the slicers and another table that displays the items the selected slicers excluded.