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 want to show in slicer)

Flight.

Flight,car (Don't want to show in slicer)

 

 

Instead combinations in slicer if I click car and bike it need to filter bike,car combination only not to filter car and bike 

 

If I click Car and Bike individually in slicer 

It need to show A4 only.

 

Give a solution for this it will be more helpful

 

Thank you PBI community

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

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.

12 Replies

  • 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 

  • parry2k's avatar
    parry2k
    Super User
    2 years ago

    James96 have you tried what I told or are you just asking the question without trying, just curious. Maybe easier if you tried it first and then we could take it from there.

    • James96's avatar
      James96
      Frequent Visitor
      2 years ago

      Hi parry2k 

      Splited on rows

      After split.

      Bike,car ---> Bike.

                            Car.

       

      Like that only it shows the combination missing the how we can filter the combination data(Bike,Car) when I click Bike and Car individually.

       

      Kindly give a solution 

       

       

       

       

       

  • parry2k's avatar
    parry2k
    Super User
    2 years ago

    James96 Based on your question the solution I gave you, should work or I'm not following your question. How far do you go after splitting? Did you use it on the slicer and select car and bike? What Name did you get? Also, how about selecting only car or bike, what names do you get?

    • James96's avatar
      James96
      Frequent Visitor
      2 years ago

      I will say with example

      "Vehicle".       "Count". "Category"

        Car.                 5.            A1

        Bike.                2.          A2

        Car,Bike.          3.          A3.

       

      Slicer.

      Bike.

      Car

      .

      When I click Bike need to show  2(sum)

      When I click car need to show  5(sum)

      When I click Bike and Car it need to show 3(sum)

       

      But if I splited like you said 

      Bike  2

      Car.   5

      Bike  3

      Car   3

      Here when I click Bike and Car it shows total sum values(13) only.

       

      I hope you got it parry2k 

       

       

       

       

       

       

       

       

  • parry2k's avatar
    parry2k
    Super User
    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.