Slicer selection show/hide rows

[wes11]

Good morning!

I have a slicer that excludes columns when an item(s) has been selected. However, I would like the entire ROW to be excluded.

For example, if "Dairy" and "Eggs" are selected, I would like to exclude the rows of any items that contain dairy and/or eggs.

I've tried several Y/N flags, filtering by counts, measures, etc.

Any ideas how I may accomplish this?

Thanks in advance!

[wes11]

Thank you @amitchandak !

[amitchandak · Accepted solution]

@wes11 , if want to remove the selected row, you need to follow the independent table approach.

You can check my video on same topic : https://youtu.be/lOEW-YUrAbE