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 ...
For now I went with a manualy copying the distinct values of the column into it's own table. Then, like you said I split that into rows and used it as a filter. It gives me the slicer I want to see and as CoreyP mentioned shows me "Option 1", "Option 2" AND "Option 1, Option 2" which I'll just say is better. I hope they don't add more options any time soon. Thanks for the help!
CoreyP
Solution Sage
Solution SageAnother option for you would be to create a second slicer which has "Single Option" and "Multiple Options" values. Add a column with count of options. Then when someone clicks the Single Option button, the selection they make on the options slicer will only show the ones with one option.