Forum Discussion

gonrodrigues's avatar
gonrodrigues
Icon for Helper III rankHelper III
10 years ago

Drill and filter

Hello,   I applied a filter for 1st lvl of my graph and then i drill down:     When i drill up again, filter is undone:     Any ideas? Even without any other filters applied (visu...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
10 years ago

I was able to replicate this but it is odd. I had a Date Hierarchy like this in my axis:

 

Date

  • Year
  • Quarter
  • Month
  • Day

 

I set a visual level filter. I then drilled down to Quarter and back up. Filter as still there. Then I drilled down to Quarter and then Month and back up, filter was still there. Then I drilled down to Quarter, Month, Day. When I came back up one level, the filter was removed.

 

Very strange. 

 

I suggest you post this in Issues and see what the feedback from the Power BI team is:

https://ideas.powerbi.com/forums/360879-issues

 

 

gonrodrigues's avatar
gonrodrigues
Icon for Helper III rankHelper III
10 years ago

Yes, it is applied to the visual.

 

Sometime it happens, sometimes doesn't... stange indeed. I will post in Issues.

 

Thanks Greg_Deckler!

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    10 years ago

    gonrodrigues - So, I had my filter set on "Month". What I am wondering is if for some reason once the drilldown gets "below" where the filter is that is when it removed on the way back up. Does that check out with your testing?

      • cvaughn67's avatar
        cvaughn67
        Icon for Advocate I rankAdvocate I
        10 years ago

        gonrodrigues Greg_Deckler I am also seeing this on one of my clustered bar charts. The filter will stay applied if I click on specific values to drill down a few levels and then back up. Then if I click the drill all arrow it will remove the filter when I drill up, but ONLY when I reach the top level. It will retain the filter on all levels for drill up except the top level. I've replicated in both the service and desktop. I can't remember this being an issue before. Hopefully they can patch this in the next update.