Skip to main content

Power BI

Needs Votes

Clear / reset any additional filters applied and passed to a drill-through page (not the main drill-through field)

Vote (4) Share
Sean N's profile image

Sean N on 19 Oct 2020 21:44:11

We need a way to be able to clear / reset on the drill-through page any additional filters applied on the originating page and passed to the drill-through page without having to leave the drill-through page.

NOT clear / reset the drill-through field itself - just the additional filters applied on the originating page and passed to the drill-through page and do that on the drill-through page!

Let's say County is the drill-through field that lets you drill-through when you've selected one.

If I don't apply any additional filters on the originating page and drill-through to the County page I can use a bookmark to clear any and all filters applied as long as they are applied on the drill-through page.

If however I select an additional filter before I drill-through to the County page say Company and pass that additional filter to the drill-through page then on the County Page I have no way of clearing just the additional filter (in this case Company). I can't remain on the County page and clear the Company selected on the originating page to show all Companies in that County without leaving the drill-through page.

A bookmark cannot clear / reset the passed filters!
We need a way to clear / reset just the extra passed filters without leaving the drill-through page!

Thanks!