Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
Solved! Go to 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.
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.
@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.
@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
@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
@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
@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.
@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.
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
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
104 | |
100 | |
99 | |
38 | |
37 |
User | Count |
---|---|
158 | |
124 | |
76 | |
74 | |
63 |