Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
nigelh54
New Member

Clearing filters from visuals

Hi Guys,

            I have a drillthrough page that accepts its data into one slicer, i also have another slicer on the page. I have set up a bookmark page but when i click the link to it it clears both slicers and clears the values from the one from the drillthrough. How can i achieve the desired effect?

 

Nigel

4 REPLIES 4
Anonymous
Not applicable

Hi there! If I understand correctly, the issue you are facing is that when you click on a bookmark link, the slicer filter as well as the data from the drillthrough is reset. To fix this, go to View->Bookmarks Pane, and right click on the Bookmark. From there, uncheck "Data". In doing so, the boomark will no longer store whatever filter, drill, or sort state you had at the time of creating the bookmark.

 

Hope this helps!

Hi Sean-Owens,

                        I have tried that but it clears all data from the slicers. What i want is for it to keep the data from the drillthrough but reset any applied filter.

 

Nigel

Hi @nigelh54 

As tested,

Check the "data" for the bookmark, bookmark will reset the filters,

Uncheck the "data", bookmark can keep the filters from previous page.

 

But you want to keep the filters from the "drillthrough" page which is filtered by the "drillthrough" feature,

As tested, it seems impossible.

 

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous
Not applicable

In that case, put the slicers to the position you want them to reset to (most likely "All"). Then, select all slicers by holding Ctrl and clicking on all of them, right click on the bookmark, click on "Selected visuals", and then click "Update".

 

As a result, the bookmark will update the slicers to the specified position above and it will not affect the graph that you have applied the drillthrough to.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors