cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
lucascolz Frequent Visitor
Frequent Visitor

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
lucascolz Frequent Visitor
Frequent Visitor

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
Super User

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.


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

Proud to be a Datanaut!


Highlighted
v-ljerr-msft Super Contributor
Super Contributor

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

lucascolz Frequent Visitor
Frequent Visitor

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