Forum Discussion

James96's avatar
James96
Frequent Visitor
2 years ago
Solved

Filter combinations

Sample dataset  Table name :- Travelers . Vehicle  Name. Bike.       A1 Car.        A2 Train.      A3 Bike,car.  A4 Flight.     A5 Flight,car A6.   Slicer Car. Train. Bike,car (Don't wan...
Need Help
  • parry2k's avatar
    parry2k
    2 years ago

    James96 because you have extra comma in car,ship value, it is like car,ship, if it is car,ship then it will work. It is an issue with data inconsistency.

parry2k's avatar
parry2k
Super User
2 years ago

James96 The best way to approach this is to split vehicle column value into rows, which you can easily do in PQ, and from there everything will be super easy. This is the right way to address this.

 

 

James96's avatar
James96
Frequent Visitor
2 years ago

I want the slicer which I mentioned above 

In slicer if I click Bike and car individually it need to filter Bike,car combination values only it means need to show "A4"

 

How it possible after converting into rows can you explain eloborate.

 

Thank you parry2k 

  • James96's avatar
    James96
    Frequent Visitor
    2 years ago

    Yes,I tried what you have said but it splited combination values into the  individual values so how we can get combination values 

    parry2k