Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
Anonymous
Not applicable

Filters reset when using the reset all filters buttons

Hello everyone, I have an issue with the "Reset all filters" button in my report.

 

I have a report with a slicer for the "Reset all filters" button, cf. the screenshot below, and the report contains 5 filters that are normally saved and locked. The report is meant to track the training completed by team members. When I search for a person in one of the filters, I can see all their data once (because someone can attend the same training again and again and we want only the lasted training completion to be seen), and all the tables are complete. Once I press the "Reset all filters" button and search for the same person again, the report "breaks." There are many duplicate training records, even though I had locked the filters and I can see that 1 filter out of 5 isn't locked anymore, and some dashboards no longer display any data, even though they did before.

 

What am I missing? Can someone please help me?

 

MissRanger_0-1728486359817.png

 

THANK YOU !!! 

1 ACCEPTED SOLUTION
rajendraongole1
Super User
Super User

Hi @Anonymous -Make sure that all filters are truly locked. 
Selecting the filter pane in your Power BI report.
Verifying that each of the 5 filters you want locked has the "Lock" icon enabled (this ensures the filters remain in place).
Re-lock any filters that might have gotten unlocked by the reset button.
2. Review Filter Dependencies:
Check if any of the unlocked filters are connected in a way that affects the logic showing only the latest completion for each person. If the reset changes that filter, it may be why duplicate training records are displayed.

https://hatfullofdata.blog/power-bi-resetting-slicers-with-a-bookmark-button/

https://forum.enterprisedna.co/t/reset-filters-without-bookmark/20397

 

 

with help of measure also we can keep the latest records displayed no matter how filters are reset. please try above and let know





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





View solution in original post

1 REPLY 1
rajendraongole1
Super User
Super User

Hi @Anonymous -Make sure that all filters are truly locked. 
Selecting the filter pane in your Power BI report.
Verifying that each of the 5 filters you want locked has the "Lock" icon enabled (this ensures the filters remain in place).
Re-lock any filters that might have gotten unlocked by the reset button.
2. Review Filter Dependencies:
Check if any of the unlocked filters are connected in a way that affects the logic showing only the latest completion for each person. If the reset changes that filter, it may be why duplicate training records are displayed.

https://hatfullofdata.blog/power-bi-resetting-slicers-with-a-bookmark-button/

https://forum.enterprisedna.co/t/reset-filters-without-bookmark/20397

 

 

with help of measure also we can keep the latest records displayed no matter how filters are reset. please try above and let know





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.