Forum Discussion
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
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?
- Greg_Deckler
Community Champion
Which drill down method are you using? If you using the single arrow in the upper right that should not happen.
v-ljerr-msftMicrosoft Employee
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? :smileyhappy:
Regards
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
