topic Re: Double drill down in Desktop

Double drill down

Anonymous — Tue, 24 Mar 2020 13:49:04 GMT

Hi all, I would like to know how I can do a double drillthrough, it has been asked here before but it was a bit unclear to me.

So I have 3 tabs:
Summary: waterfall chart
Company Costs: analysis on company costs, with some summaries of accountant line items
Company Costs Detailed: detailed analysis on company costs. With all line items (whitout summary)

I can drill trhough by clicking on the waterfall chart and go to the desired tab (Summary --> Company Costs. But for some reason I can't drill down from Company Costs --> Company Costs Detailed.

summary tab + drill down

Company Tab + Missing Drill through + Drilltrhough fields

Company Costs Detailed Drill throughs

So i want to drill throught from Summary --> CompanyCosts --> CompanyCostDetail

any ideas?

Re: Double drill down

amitchandak — Tue, 24 Mar 2020 14:53:25 GMT

If both the pages are enabled for drill through and both has keep filter. then it should work?

Re: Double drill down

Anonymous — Tue, 24 Mar 2020 16:27:38 GMT

Yea I also don't see why it isn't working

Re: Double drill down

amitchandak — Tue, 24 Mar 2020 16:39:20 GMT

Is it possible to share pbix, after removing the sensitive information

Re: Double drill down

Anonymous — Tue, 24 Mar 2020 19:19:12 GMT

amitchandak How can I easily and quickly remove data in PowerBI? Should I do in the data source itself (after takena copy ofcourse)?

Re: Double drill down

Anonymous — Wed, 25 Mar 2020 06:28:55 GMT

amitchandak it is fixed, I made a really REALLY stupid mistakes. I right clicked on the title of I wanted to do the second drill through while it should be on the values 🙄.