Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
James96
Frequent Visitor

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

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

1 ACCEPTED SOLUTION
parry2k
Super User
Super User

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



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

View solution in original post

12 REPLIES 12
parry2k
Super User
Super User

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



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

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

Thank you @parry2k 

parry2k
Super User
Super User

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



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

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
Super User
Super User

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



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

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
Super User
Super User

@James96 split on rows or on columns?



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

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
Super User
Super User

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



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

parry2k
Super User
Super User

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

 

parry2k_0-1694811910030.png

 



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

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 

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

@parry2k 

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.