Forum Discussion

Manish1198's avatar
Manish1198
Icon for Helper I rankHelper I
1 year ago
Solved

Remove 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...
  • v-saisrao-msft's avatar
    v-saisrao-msft
    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.