cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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.

4 REPLIES 4
Highlighted
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?

Highlighted
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.


---------------------------------------

@ me in replies or I'll lose your thread!!!

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!




Microsoft
Microsoft

Re: Drilling down removes filter on other visualization

Hi @lucascolz,

 

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

 

drilldown.gif

 

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

 

Regards

Highlighted
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.

 

https://makeagif.com/i/_SKLZs

 

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

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors