Table name :- Travelers .
Bike,car (Don't want to show in slicer)
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.
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
@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?
I will say with example
"Vehicle". "Count". "Category"
Car. 5. A1
Bike. 2. A2
Car,Bike. 3. A3.
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
Here when I click Bike and Car it shows total sum values(13) only.
I hope you got it @parry2k
Splited on rows
Bike,car ---> Bike.
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.
@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.
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 November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.