Skip to main content

Power BI

Needs Votes

Back-button feature to clear selected drillthrough filter value

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

7716162b f4d4-431e-81ee-4815d1e91dc4 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

8400eb66 c798-47a5-93be-ae7828282e23 on 06 Jul 2020 00:08:08

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

Agreed

TonDeli's profile image Profile Picture

3a5cab2c 75a3-476e-9f7d-308cfeabb53e 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

fcfb13a5 85bd-4fb5-a97a-0f869a36a1d1 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

5690df7c cb18-400b-aaa0-4ed094836896 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

265e99aa 4a6d-48c1-b508-8cf54fdf7089 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

a3309361 99be-ea11-a812-000d3a8ddfb2 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

0478fc0c 8f9a-47e9-85ed-7b6a88740fb1 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

be2ed532 a54d-4d4f-bfff-262f17de0a1c 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

587ebb0a 034a-46d9-b784-80448684ab36 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