Friday, 3 October 2025

Remove Filters on drill through Page

Step-1

    Create a Remove filter button as shown below


Step-2

    Create a bookmark to clear filter and update the bookmark with all the data in that page.



Step-3

    Tag that bookmark to the created button as shown below.



Step-4

    Now, after the drill through is applied, you can go the page and click

    on remove filters to remove the drill through filter and show all the data.









Filter pane in bookmarks

 



    Once Slicer is selected and Close button is clicked, Then the filter is not reflect Since we need to make some changes in the bookmark as shown below


Step-1

    Click on the bookmark which is pointing for Close Button.






Step-2

    Uncheck the data as shown below




Power BI One Slicer to filter other slicers based on Items that has value only without BI Direction



Ref Video : 

https://www.youtube.com/watch?v=cyOquvfhzNM

https://www.youtube.com/watch?v=MeLaZFst02E


Step-1

    Create a measure like below.

Cascading=

   COALESCE(DISTINCTCOUNT('table'[ID]),0)

Step-2
    Put the created measure in this in this visual section of slicer pane as shown below


Step-3
    Now in the filter slicer only the relevant data related to the another selected slicer will only appear.