Forum Discussion

OneWithQuestion's avatar
OneWithQuestion
Icon for Post Prodigy rankPost Prodigy
8 years ago
Solved

Possible to clear drillthrough filters?

I asked this about 6 months ago and it was not yet possible, but I was wondering if this has changed?   I love the drill through feature but my users often want to CLEAR out a drill through.   Th...
Need Help
  • PaulDBrown's avatar
    PaulDBrown
    8 years ago

    OneWithQuestion

     

    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.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hello,

Did you find the solution or work around for this?

Thanks

shaunwilks's avatar
shaunwilks
Icon for Helper V rankHelper V
7 years ago

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.

  • kwatson1's avatar
    kwatson1
    Frequent Visitor
    6 years ago

    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. 

  • RobinNeven's avatar
    RobinNeven
    Icon for Helper I rankHelper I
    5 years ago

    We would be interested in a nice alternative solution for this if it came along (so instead of the duplicate page solution which doesn't work for us)!

     

    I have no other way now but to simply instruct our users to clear any previous filter selections through a text box on the report page.