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.
Community SupportHi Manish1198,
Thank you for reaching out to the Microsoft Fabric Forum Community.
Thank you ajaybabuinturi, for your valuable insights.
I’ve reviewed your setup and fully understood your requirement you want to clear all slicers and drillthrough filters on the Detail page, but retain the selection made in the MonthYear slicer.
I’ve reproduced your scenario and I’m happy to confirm that the expected behavior can be achieved by configuring the bookmark using the “Selected visuals” option, excluding the MonthYear slicer when creating the bookmark.
Steps I followed:
- On the Detail page, I selected all slicers except MonthYear.
- Created a new bookmark and named it ClearOtherFilters.
- In the Bookmark settings, I enabled: Data ,Display ,Current Page,Selected visuals.
- Assigned this bookmark to the "Clear all filters" button using the Action property.
Now, when clicking the “Clear all filters” button:
- All other slicers and drillthrough filters are cleared
- The selected MonthYear remains unchanged, just as you intended
For your reference, I’m attaching the updated.pbix file with the working solution.
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 v-saisrao-msft . Thank you for your response.
I have looked into the file and the the Clear all filters button as intended clears the slicers but fails to clear the drill through filters. Can you please check if it is possible to clear the drill through filters as well.
- v-saisrao-msft
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.
- v-saisrao-msft
Hi Manish1198,
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.