Drill Through reset filters

[klehar]

Hi,

I have a bar chart of sales by ship mode that drill throughs to another page to enable detailed table

So If i click Ship Mode = Standard then only standard is shown on the drill through page.

However what I want is after I go back to my bar chart page, my drill through page should reset its filters to show all values

Can i do that.

If this is not possible directly is there a workaround?

[v-yalanwu-msft]

Hi, @klehar ;

Is your problem solved? If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

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

[v-yalanwu-msft]

Hi, @klehar ;

I'm not quite sure what you mean. Could you give me an example to illustrate?

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

[v-yalanwu-msft]

Hi, @klehar ;

Method 1:you could clear the filter after drill through.

Method 2:if you don't want to keep the filter about drill through ,To jump to another interface that is not affected by the first page (show all), use button+ Page (or button+bookmark).
1.add button.

2.set action.

the final show:

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

[klehar]

I didn't get the second solution

I want to enable automatic learing of filters when the user navigates back to main page

[edhans]

No, it retains its settings. Pages you drill through to should not be used as normal pages as the drill through function is confusing. I always hide my drill through pages so the user can only get to them via the drill through.

You can clear the filters on the drill through page - they are the italics filters in the lower right. But that isn't intuitive for users. You could also place a button at the top that says "clear filters" and connect that to a bookmark on that page that resets filters to your preference.

[klehar]

@edhans appreciate your quick response

This is what I did so far. Seperate the dirll through page and details page

However my report has exploded and hence I wanted to combine my table view page and drill through page so that they can serve 2 purposes.

[edhans]

That is the price paid when trying to get 1 page to serve 2 purposes. The software isn't designed that way. It assumes 2 pages, and the drill through is hidden only accessable via a drill through action.