Retain filter selection when coming back from drill through detail-page

[Anonymous]

I have a simple master-detail kind of report setup, where in my first report page i have a table visual which enables the user to select a row, and drill through to the detail page.

On the detail page, I have a button with action "Back", and another button with action "page navigation" with destination to the master page. None of the buttons, when clicked retain the row-selection on the master-page, which leads to confusion since the customer does not remember which row she had selected when she first started her "drill-through journey".

Please do not suggest to use bookmarks, as the solution must work regardless which row is selected.

My questions are:

1) Am i missing something, should the row be kept selected on returnal?

2) Is this known behaviour?

3) Is there something I have to configure additionally to make it work?

4) Is there some other kind of workaround, like passing on a parameter from the detail page (where I have i.e. the identification number in a card visual) to the master page so that I could at least include that in a card visual?

Thank you for your support!

[camielendert]

Whenever a visual is hidden or another page is opened in PowerBI table selections are reset. There are 2 ways I have bypassed this in the past. 
Option 1: Extend the canvas and put your drill through table at the bottom and then users will have to scroll down to see the table.
Option 2:  Create a button for drill through and a button for returning from the drill through. Then place your drill through table on top of the selection table (if it is see through you will have to put an image under the drill through table to hide the selection table). Then you create 2 bookmarks and 2 buttons. One where you make the drill through table visible and the return from drill through button invisible make sure to leave the selection table visible in this one but keep it behind your drill through table so users can't see it, and the second bookmark you make the drill through and return from drill through button (and image if you used one) invisible and the drill through button visible. Now connect these to the bookmarks to the buttons you made and then the user can select the row they want in the table, click on the drill through button you created and then click on the return from drill through button and the selection will remain. 

[Anonymous · Accepted solution]

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.

[Anonymous]

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.