Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
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?
THANK YOU !!!
Solved! Go to Solution.
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
Proud to be a 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
Proud to be a Super User! | |
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.