Forum Discussion

TChapa's avatar
TChapa
Regular Visitor
3 years ago

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 ...
Need Help
Tutorial Requests
parry2k's avatar
parry2k
Icon for Super User rankSuper User
3 years ago

TChapa this is a data prep issue, and you have to rethink about how you want to make it work - and this is the right approach, otherwise, you will end up creating some complicated DAX measures to create the report. The choice is yours - I can only suggest what is best.

  • TChapa's avatar
    TChapa
    Regular Visitor
    3 years ago

    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's avatar
      CoreyP
      Icon for Solution Sage rankSolution Sage
      3 years ago

      But 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. 

      • TChapa's avatar
        TChapa
        Regular Visitor
        3 years ago

        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.