Forum Discussion
Helper IRemove drill through filters
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.
Helper IHi ajaybabuinturi . Thanks for your response.
I understand removing the initial value by clearing the slicer and updating the bookmark would help.
But I have the MonthYear(single select slicer) and all other slicers on Overall tab(Page1) synced to Detail tab(Page2). (So user doesn't have to select the slicers again in Detail tab)
When a user selects a monthYear and drill throughs from Overall tab to Detail tab, the user will see data wrt. applied slicers and drillthrough filters.
Now, if user want to clear all filters in Detail tab, the bookmark changes the MonthYear to the initial value.
Here, the bookmark should clear all filters but not clear/change the MonthYear slicer. Is this achieveable?
Thanks