Forum Discussion
Retain filter selection when coming back from drill through detail-page
Hi v-kaiyue-msft and thanks for responding!
I investigated your provided pbix file and understand the proposed solution! Very clever, to use drill-through in both directions in order to also keep the first page filtered!
I tried to apply your solution to my case, where I hide the drill-through function behind buttons, which leaves me to the point where I need the customer to (re)select a datapoint in the 2nd page, in order to get the Drill-through-Button from inactive state to active - which is just really unintuitive in itself.
Therefor I decided to "just live with" the issue of loosing the row-selection for now.
Hi Anonymous ,
By default, Power BI does not retain row selections when returning from a drill-though page. This behaviour is known. Unfortunately, there is no direct configuration option to preserve row selections after a drilldown.
You do not want to use bookmarks, but hopefully this solution will help.
1. Create a bookmarklet for the main page.
2. Create a button for the main page and select the bookmark you just created in the action.
3. Add the same Drill-through field to the details page.
4. At this point you can redrill from the details page to the main page.
5. At this point, the main page will display the fields that were just displayed on the details page, click the all button to display all the fields.
If your Current Period does not refer to this, please clarify in a follow-up reply.
Best Regards,
Clara Gong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.