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.
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.