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 ...
I agree, the data isn't the best. It isn't mine and I have little control over it. That is why I'm looking for a backwards solution like the one I'm describing. I'm just trying to do the best I can with what I got which is why I'm looking for a solution to my specific use case even if it's creating some complicated DAX measures.
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.