Forum Discussion
Helper IIDrill through to multiple pages
I have a report page with two drill throughs connected to the same column. From the main report page, I can right-click on a row in the table and navigate to either drill-through page 1 or drill-through page 2. If I go to drill-through page 1 and want to see drill-through page 2, I have to go back to the main report page, right-click on the row in the table, then select drill-through page 2.
I'm looking for a way to navigate from drill-through page 1 directly to drill-through page 2 (and vice versa). Suggestions?
Hi , lburgess
Please make sure your drill-through pages all have the same drill-through fields.
Here is a demo.
The field "Country" is present in every visuals ,and I use the field "country" as the drill through field in page 2,page3,page4
In addition ,we can‘t create drill through for cards currently .( Page 3 to other page)
You can vote for this idea and add your comments there to make this feature coming sooner. https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/34482268-create-drillthrough-for-cards
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
12 Replies
- Greg_Deckler
Community Champion
On drillthrough page 1 you do not have the same column you were drilling into?
lburgessI do. It’s displayed as a card. There is no drill-through option available for a card. I changed it to a table, but still no option to specify a drill-through column.
- amitchandak
Super User
lburgess ,
Hope all setup is done as mentioned in
https://docs.microsoft.com/en-us/power-bi/desktop-cross-report-drill-through
https://docs.microsoft.com/en-us/power-bi/desktop-drillthrough
- v-easonf-msft
Community Support
Hi , lburgess
Please make sure your drill-through pages all have the same drill-through fields.
Here is a demo.
The field "Country" is present in every visuals ,and I use the field "country" as the drill through field in page 2,page3,page4
In addition ,we can‘t create drill through for cards currently .( Page 3 to other page)
You can vote for this idea and add your comments there to make this feature coming sooner. https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/34482268-create-drillthrough-for-cards
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.I needed to do something like this and achieved it using the Sync Slicer functionality and the Chiclet slicer as it allows a default selection to be forced as the page loads. Adds a small delay on the inital drillthrough target, but otherwise works well.
Setting it up is a little involved so I put together a blog post and video.
I hope this helps 🙂
- AnetaK
Helper V
It works when you alway drill to one page.
In my case there are three drill pages, user can chose which one to select.
It works for the first time, but when user selects a different page, there is still the previous drill filter used.
