Forum Discussion
Possible to clear drillthrough filters?
- 8 years ago
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.
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.
Just 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.