Clear all filters in drill through

[NIXONNIXON]

I have a drill through page in my dashboard that when the user navigates to, the green clear all filters enables. 

When the user clicks on it, all the drill through filters reset. Is there a way to disable that? 

I.e. 

Country - sales

Canada - $100

United States - $200

Mexico - $400

Drill through to canada. 

I have a card that says total sales = $100

Clear all filters appears, I click it. 

Now total sales = $700.

This makes it very confusing for the user. 

I need to make it so that if the green clear all button is pressed, the filters remain for Canada. 

Thank you. 

[Anonymous · Accepted solution]

Hi @NIXONNIXON ,

Your filters at this point are passed through the drill -through field, which is how drill-through work; if you clear the filters on the target page, the content of the target page will go back to the default.

For more details, you can read related document: Set up drillthrough in Power BI reports - Power BI | Microsoft Learn

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.