Drill and filter

Question

Hello,&nbsp;I applied a filter for 1st lvl of my graph and then i drill down:&nbsp;&nbsp;When i drill up again, filter is&nbsp;undone:&nbsp;&nbsp;Any ideas?&nbsp;Even without any other filters applied (visual, page, report), this keeps happening...&nbsp;Thanks!&nbsp;PS: If i change my levels, 2 to 1 and 1 to 2, filter works...

cvaughn67 · Answer

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.

greg_deckler · Answer

How are you applying the initial filter, to the visual itself?

greg_deckler · Answer

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 · Answer

Yes, it is applied to the visual.&nbsp;Sometime it happens, sometimes doesn't... stange indeed. I will post in Issues.&nbsp;Thanks&nbsp;Greg_Deckler!

gonrodrigues · Answer

Hey&nbsp;Greg_Deckler&nbsp;Yes it does! I tried also on a treechart and happened again. When the drilldown gets "below", filter is removed!It must be a bug :/&nbsp;If you want to leave some comment:https://ideas.powerbi.com/forums/360879-issues/suggestions/13890087-filter-removed-after-drill-down-and-drill-back-up&nbsp;

Forum Discussion

Drill and filter

6 Replies

Related content

Removing Drill Down Filters

Remove drill through filters

Drill Through

Omit filter from drill through

Drill Through - Keep all filters but Ignore Financial Year Slicer Filter