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?
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?
Which drill down method are you using? If you using the single arrow in the upper right that should not happen.
Proud to be a Datanaut!
Using drill down options shouldn't reset filters on other visualizations.
Could you be more precisely with your issue by posting some screenshots?
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.