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 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.
Community SupportHi 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.