Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Cross Drill through multiple categories

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.