Forum Discussion
Create a slicer to filter CSV column by individual values
I have a column with CSV values. I want to make a slicer that can filter the data based on individual values in the CSV. If I drag the Options column into a slicer I get the Red slicer which shows ...
CoreyP
Solution Sage
Solution SageBut what if a user wants to see rows that have only Option 1 and only Option 4? If you somehow achieve what you're wanting, users would lose this ability.
You bring up a good point. The requirement I was given was an additive filter. If multiple options are selected show only rows containing both. That's why this has been such a headache.