Skip to main content
Microsoft Idea

Power BI

Needs Votes

Back-button feature to clear selected drillthrough filter value

Vote (719) Share
TonDeli's profile image

TonDeli on 11 Sep 2017 17:55:57

As drillthrough function we use a filter and we give value for it from other report page. I click back-button and it will take me back to where I was before. In the background filter value stays unchanged. I use drillthrough function again. Filter value changes and I see visuals filtered with that value. I use back-button again. I navigate to that report page manually and to my surprice value selected in prev step is still selected. I know that I can open my filter selections and clear selected value but I'd like to do is to start exploring my data without any preselected drillthrough filters. Filters in filter pane are a bit confusing to end-users and some of them cannot even find them.

Comments (20)
TonDeli's profile image Profile Picture

Michael Bernier on 05 Jul 2020 23:19:49

RE: Back-button feature to clear selected drillthrough filter value

While hiding the drillthrough page might be helpful to some, I need to keep it visible for one of my clients because they jump back and forth between it and other pages. Being able to clear the filters without having to teach them how to use the Filters pane, either through implementing it with the Back button action or a separate function, would be most helpful.

TonDeli's profile image Profile Picture

Tobias Owen on 05 Jul 2020 23:09:37

RE: Back-button feature to clear selected drillthrough filter value

With the January update allowing authors to hide drill-through pages (so they are no longer browsable tabs on your report) should address this issue.

TonDeli's profile image Profile Picture

Adam Power BI User on 05 Jul 2020 23:06:49

RE: Back-button feature to clear selected drillthrough filter value

Existing functionality is a little clumsy given even after hitting the back button the user can navigate to the page through the pages at the bottom of a report..it's confusing they should have to clear the filter themselves once going back

TonDeli's profile image Profile Picture

Allan Bond on 05 Jul 2020 23:05:57

RE: Back-button feature to clear selected drillthrough filter value

I support using the method employed by Tableau where the developer is given the choice of how drill-through filters should behave:

"Clearing the selection will: () Leave the filter, () Show all values, () Exclude all values"

TonDeli's profile image Profile Picture

Power BI User on 05 Jul 2020 23:02:40

RE: Back-button feature to clear selected drillthrough filter value

Yes, the ability to show the "drill through filter" in a filter slicer (drop down box) with the option to clear it would be VERY helpful. Especially when we do a drill through to say a given state to show a state detail view, but then the user goes "Hmm ok now I want to see Texas" they should be able to click the drop town and change it WITHOUT having to go back and re-drill.

Also, a "Limit" option so that when a user goes to a drillthrough configured page it ALWAYS displays 1 and only 1 record (so if they were to clear the drillthrough filter manually it wouldn't show all 50 states at once as the page was designed to show only a single record not sum all 50 together)

TonDeli's profile image Profile Picture

Mark Robinson on 05 Jul 2020 22:59:28

RE: Back-button feature to clear selected drillthrough filter value

I was going to submit the same idea. Report drill through is a fantastic feature, and works great if you only ever use drill through to navigate from one report page to another. But after using drill through, if you then navigate to the same report page manually the drill through filter is still applied and it gets a little fiddly and confusing. Having the back button clear the drill through filter would be perfect!

TonDeli's profile image Profile Picture

Kristinn Thor Sigurjonsson on 05 Jul 2020 22:59:21

RE: Back-button feature to clear selected drillthrough filter value

There are a few posts around the same issue, would be good if it would be possible to merge them... https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/31397962-clean-drillthrough-filter-on-back-button

TonDeli's profile image Profile Picture

Paul on 05 Jul 2020 22:59:18

RE: Back-button feature to clear selected drillthrough filter value

The back button clearing the filter would help a lot.

TonDeli's profile image Profile Picture

Caren Khachatrian on 05 Jul 2020 22:59:18

RE: Back-button feature to clear selected drillthrough filter value

Excellent idea.
We either need an auto clear or an explicit Clear Filter button.

TonDeli's profile image Profile Picture

Power BI User on 05 Jul 2020 22:59:06

RE: Back-button feature to clear selected drillthrough filter value

Thanks for posting this. I was surprised when I realized the drillthrough filter holds after going "back" and the only way to release it is through the filters pane. We discourage our users from using the filters flyout pane because they can really mess up their data if they adjust filters.