Filter combinations

[James96]

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

[parry2k · Accepted solution]

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

[James96]

Yes,it's a demo data only now it's working fine.

Thank you @parry2k 

[parry2k]

@James96 Yes, it is much clearer now, see the attached solution, and tweak it as you see fit.

[James96]

I tried your pbix file but it's not working for my scenario 

I have attached drive link for my pbix link in that file if we click car it shows car count if I click ship it shows ship count but if I click car and ship it shows blank this is the scenario 

Kindly give a solution @parry2k 

https://drive.google.com/file/d/13T_YIS6no5Fq9klYSZx60oYlszgt7A5W/view?usp=drivesdk

https://drive.google.com/file/d/13T_YIS6no5Fq9klYSZx60oYlszgt7A5W/view?usp=drivesdk 

[parry2k]

@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]

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]

@James96 split on rows or on columns?

[James96]

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]

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

[parry2k]

@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]

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]

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

@parry2k