Forum Discussion
Display rows excluded by a slicer
Community ChampionHi JLOV75
Okay, managed to locate something I used sometime ago that aligns with what you are after. Hoping it can also assist you in this:
https://datakuity.com/2019/06/13/power-bi-exclude-data-based-on-slicer-selection/
Given that you want a table that includes the selected items from the slicer and one that does not include the slicer, you may need to have two slicers on the page and just use Edit Interactions with your Table visuals to achieve the perfect outcome. With the two slicers, one can be hidden underneath the other if you do not want them both visible (as the hidden one can be set to interact with one specific table e.g. included or excluded data).
Hope this helps mate.
Theo
I did find this one also and it works with a disconnected table; the issue is my actual table is about 500,000 rows and I have more table not present in the example the are many 100,000's rows each also so I'm hoping to achieve this without yet another 500,000 row table for this one function...
is it possible to use a variable in the measure to reference rather than a disconnected table?