Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I'm trying to create a cross drill feature for the following data:
The idea is to allow user to drill through any category. For eg, a user can look at total debit for Category A -> Category B -> Category C or Category B -> Category A -> Category C
To implement this, I setup 3 sheets each corresponding to 1 category and I dropped all the other categories under the drill through section on the visualization:
This seems to serve the purpose, but the challenge is that after I drill under 1 category, I want the user to know what category they have drilled down into.
For eg, If I drill down into Category B for 'Female' I can see the data for the 'Female' category but the chart title doesn't say what category I have selected (Female in this case). I can resolve that using multi-row cards but I want the user to drill to third level and that's where the cards breaks.
I'm very new to power BI and would like to know if someone has any creative solution to deal with this scenario.
Thanks.
Solved! Go to Solution.
Update: I was able to figure out the solution. The solution came from this video on Guy in a cube channel: https://www.youtube.com/watch?v=XXv13mkjV2Y
Update: I was able to figure out the solution. The solution came from this video on Guy in a cube channel: https://www.youtube.com/watch?v=XXv13mkjV2Y
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
13 | |
2 | |
2 | |
1 | |
1 |