Forum Discussion
wes11
5 years agoFrequent Visitor
Slicer exclude values (list)
Hello! I am trying to create a slicer that excludes values when selected. I am able to get it to work with selecting one (1) value. When I select multiple values, it does not work. Any insight is greatly appreciated.
IMAGE:
(1st table) no filter applied, "Dairy" items appear.
(2nd table/slicer) selected "Dairy", "Dairy" items removed.
(3rd table) shows how the data is stored, column with list, broken out into distinct values
Read my article here https://exceleratorbi.com.au/items-not-selected-slicer/
2 Replies
- MattAllingtonCommunity Champion
Read my article here https://exceleratorbi.com.au/items-not-selected-slicer/
- wes11Frequent Visitor
Thank you MattAllington! I was able to follow this and get it to work. Although my output was not near as cool as the Simpsons. 😆 Thanks again!