Skip to main content

Power BI

Needs Votes

Back-button feature to clear selected drillthrough filter value

Vote (722) 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 (18)
TonDeli's profile image Profile Picture

Ben Moore on 12 Jul 2021 19:55:12

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

We needed this functionality like 2 years ago!

TonDeli's profile image Profile Picture

Ivan on 06 Jul 2020 00:08:52

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

This issue needs to be addressed by Microsoft. The results from the drill through are misleading if filters from a prior drill through are not cleared.

TonDeli's profile image Profile Picture

Matthias Ebinger on 06 Jul 2020 00:08:08

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

Agreed

TonDeli's profile image Profile Picture

james on 06 Jul 2020 00:06:18

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

Ready for this to be live now...!!

TonDeli's profile image Profile Picture

Power BI User on 06 Jul 2020 00:04:12

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

Even i am facing same issue cache is not clearing. 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

Cisab on 06 Jul 2020 00:00:44

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

I was very surprised that Back doesn't automatically clear the drill through filters.
I can't think of any scenario where the current behavior of keeping the filters would be desirable.

TonDeli's profile image Profile Picture

Karim ABDELOUAHAD on 05 Jul 2020 23:59:33

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

no news???

TonDeli's profile image Profile Picture

Power BI Ideas Admin on 05 Jul 2020 23:30:33

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

yes, the drill thorough back button should release the filters. In cases where the detail tab is not hidden and user wants to access the whole detail data without any filters on, it's getting tough to handle... I vote this option.

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.