Forum Discussion

TChapa's avatar
TChapa
Regular Visitor
2 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
2 years ago

TChapa you need to split the options column value into rows:

 

click transform data -> select option columns -> arrow next to split column and then select "split column by delimiter" -> advance options -> Rows -> Ok 

 

 

 

  • TChapa's avatar
    TChapa
    Regular Visitor
    2 years ago

    The problem with splitting it into rows is that it more than doubles the amount of records which throws off all the other visuals. Then if I try to select multiple options (say Option 1 & Option 4 like in the example) it shows me records with "Option 1" and records with "Option 4" AND "Option 1, Option 4" which is not what I want.