Forum Discussion
Manish1198
Helper I
1 year agoRemove drill through filters
I want to remove drill through filters in a page2(Detail) except MonthYear slicer. I created a bookmark(Clear all filters) clearing all the slicers and drill through filters. The bookmark removes all...
- 1 year ago
Hi Manish1198,
The issue you're encountering where the "Clear all filters" button resets slicers but does not drill through filters is a known limitation in Power BI. Bookmarks cannot clear drill through filters because these filters are applied through the navigation context when drilling through from one page to another.
Alternate Work Around- Create a duplicate of your current Detail page. On this new page, remove any drill through fields to prevent automatic filtering.
- Add a Navigation Button: On the original Detail page, add a button labeled .
Set this button to navigate to the duplicated Detail page.
- Maintain the Month Year slicer: Ensure the Month Year slicer is synchronized between both pages to retain its selection.
By clicking the button, users will navigate to a version of the Detail page without any drill through filters applied, effectively clearing them.
If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.
Thank you.
Manish1198
Helper I
1 year agoajaybabuinturi
Please find the link of the sample report. You can download the pbix file
Sample_Report
Thanks.