How to reset the slicer after drill through?

[Amyries]

Hi everyone, 

I want to ask about the slicers keeping the last selection across drillthrough?
Context: A Power BI report has two pages: 

1, Project List → summary of all projects. 

2, Project Detail → detailed breakdown for one project (members, etc.). 

From the Project List, users can drill through into Project Detail for a specific ProjectKey. On the Project Detail page, there’s a slicer on MemberName to filter project members 

Current Flow 

User selects Project_ID = 001 on the Project List page and drills through. 

1, On the Project Detail page, the slicer correctly shows members of Project 001 (e.g., Alice, Bon). 

2, User selects Alice in the slicer. 

Then the user goes back to Project List, selects Project_ID = 002, and drills through. 

3, Project Detail now shows members of Project 002 (e.g., Max, POP).

4, Problem: The slicer still shows Alice as selected, even though Alice is not a member of Project 002??

Approach: I tried to create a reset button, but it only works for slicers with multiple selections. I would like to keep it as single selection, so this approach doesn’t really meet my requirement.

Data: https://docs.google.com/spreadsheets/d/1sjKIBe4mWzeYW0eMhchCMTXu1-h0vdVa/edit?usp=sharing&ouid=10623...

PBIX: https://drive.google.com/file/d/1-5L8il71FhquC7f8FQk-PZJK2zz4hcAt/view?usp=sharing 

Question?

1, Can anyone please help me find a solution to handle the "remember" function of the slicer?

2, Do you have any suggestions? I’m currently using drillthrough to navigate from the Project List to the Project Detail, but I’d be happy to hear alternative ideas.

I really appreciate your help 🙂

[Shahid12523]

Problem: Single-selection slicers remember old values across drillthrough, showing invalid members.

Solutions:

• Dynamic slicer table/measure – filter MemberName by ProjectKey so only valid members show. Old selection disappears automatically.
• Hidden synced slicer – constrain visible slicer to current ProjectKey.
• Bookmark + reset button – create a bookmark of default slicer state and assign to a button.
• Alternative: Avoid drillthrough; use a Project slicer on the same page to dynamically filter details.

✅ Best: Use a dynamic table/measure so slicer auto-resets per project.

[Amyries]

Thank you for your response!

I tried all the solutions you suggested, but they didn’t work as I expected.

May I ask if there is another way to view the project details besides using the drill-through function?

[kushanNa]

Hi @Amyries 

If your purpose is only "viewing" project details, then you can use the Tooltip pages feature. This way, you don’t need to drill through—you can see the details on the same page, please check the following link

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-tooltips 

[kushanNa · Accepted solution]

@Amyries 

Meanwhile, have you tried adding a new column called ‘All’ to the FilterMemberTable to see if it matches your requirement with the bookmark approach? This should work for single selections as well.

I have attached the pbix file for your reference

[Amyries]

Thank you! This is very good idea!

[rohit1991]

Hi @Amyries 

This is expected - drill-through will always carry the last slicer value. To fix it, you have two reliable options:

1. Add a Reset button with a bookmark (clears the slicer each time).

2. Keep the slicer unsynced, so every drill-through opens fresh without the old selection.

If you want filters to pass automatically, use the drill-through field instead of relying on the slicer.

Note:-The cleanest fix is either the Reset bookmark or unsynced slicer.