Forum Discussion
Post ProdigyPossible to clear drillthrough filters?
1. Isn't the Filter pane visible on the right of the view in the Power BI service?
2. You can use bookmarks within a report itself (no URL needed). Here's how (NB, if you are not on the most recent release of Power BI Desktop - March 2018 - you will have to enable the Bookmark feature in PBI Desktop under File > Options and settings > options > preview features > select "Bookmarks". I think that in the March release the feature is enabled by default.)
Then follow the process seen in these screenshots (while on the page where the drill-through takes you to):
Once you have it set up, you can test it by ctrl + clicking on the image on Desktop, or directly clicking it on the Power Bi service.
Hope it helps!
Regards,
Paul.
Community Champion
1. Isn't the Filter pane visible on the right of the view in the Power BI service?
2. You can use bookmarks within a report itself (no URL needed). Here's how (NB, if you are not on the most recent release of Power BI Desktop - March 2018 - you will have to enable the Bookmark feature in PBI Desktop under File > Options and settings > options > preview features > select "Bookmarks". I think that in the March release the feature is enabled by default.)
Then follow the process seen in these screenshots (while on the page where the drill-through takes you to):
Once you have it set up, you can test it by ctrl + clicking on the image on Desktop, or directly clicking it on the Power Bi service.
Hope it helps!
Regards,
Paul.
Helper VJust a quick one on this because I think the drill through pages could be so much better.
Yes the bookmark feature will remove the drill through filter and allow selection from a slicer or something of a different code.
However the major problem happens when you leave the page.
If you use the page as a drill through from another page, the next time you get to the drill thru page the item from the slicer you previously selected AND the drill through item are also selected.
The drill through function is great and all but most want to be then able to change the item selection from that page via a slicer, and not have to go to the filters tab to do so.
I am not sure if you had any suggestions in this space would be good to get the page working correctly.
Currently I have a duplicate of the drill through page that has a slicer on it so the user can select their own item.
It means having to duplciate all visuals on the drill through page on a second one.
Hello,
Did you find the solution or work around for this?
Thanks
- shaunwilks
Unfortunately there is no great workaround to this.
Microsoft would say to manually clear the drill through filter from the filter tab.
We all know that from a user consumption point of view that is no workable to do everytime you use the page.
What we did was to create a duplicate of the page and on the drill through page put a Search image on the page that moves the user to the duplciate of the page that has the filter provided as a slicer on the page.
So we of course hate it because we have to maintain two pages for the same functionality and keep the two pages up to date. but its a workaround meaning that they can drill through but then if they want to change the drill through record we essentially have them jump to a indentical page to do that.
Desktop Version:
Go to the Visualizations pane on the right and under fields and Drill through, hover on any filters that do NOT say "is (All)".
Click on the eraser icon to clear the selection.Online Version:
Go to the filter pane to the right of the report. Click on the eraser icon to clear any selections (any that do NOT say "is (All)". This will work if the creater has chosen to show the filter pane once published and has not locked the individual filters you are trying to clear.
