Showing results for 
Search instead for 
Did you mean: 
New Member

Drilling down removes filter on other visualization


I have two graphics in my report, a cluster bar showing items in my shop and a doughnut showing the cost breakdown for the items in four levels.


What I want to do is filter a specific item in the cluster bar chart, and drilldown through its breakdown.


But as I select the item in the first graph and drilldown in the second, I lose the filter in the first, and have to select the item again.


Is there anything that can be done to maintain the filter as i drilldown in the other graph?


Thank you.

New Member

Drilling down removes visualization filters

I have two visualizations, one clustered bars, showing items from a list in my shop, and a doughnut graph, showing the cost breakdownfrom them.


What I want is to select an item, and go through his cost breakdown, drilling down and up, but when I select an item and drill down inside the doughnut graph, i lose the item selection i had in the clustered graph.


Is there a way i can maintain the selection i had as i drill down the other visualization?

Super User IX
Super User IX

Re: Drilling down removes filter on other visualization

Which drill down method are you using?  If you using the single arrow in the upper right that should not happen.


Not link spamming! If I posted a link in reply it is because I did assume you know how to search the web but thought it was the fastest way to fix your issue.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


Re: Drilling down removes filter on other visualization

Hi @lucascolz,


Using drill down options shouldn't reset filters on other visualizations.




Could you be more precisely with your issue by posting some screenshots? Smiley Happy



New Member

Re: Drilling down removes filter on other visualization

@v-ljerr-msft @Greg_Deckler

Thanks for the answers, it sure is strange, because what happens in my power bi is different from the gif you have posted @v-ljerr-msft. I couldn't manage to put images in this comment, still struggling with power bi forum, but here is a link to a gif with my screenshots.


I do the same way the other gif did, click in one bar of the clustered bar chart, so i can filter the doughnut. When i drilldown inside the doughnut chart with the arrow in the up right side, i lose the selection i had done in the bar chart.


Thank you

Helpful resources


Microsoft Ignite

This will be a conference that you do not want to miss!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Don't miss the Power BI Dev Camp this week!

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors