cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
lucascolz
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
v-ljerr-msft
Microsoft
Microsoft

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

@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

lucascolz
New Member

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

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!!!
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Learn Power BI 2nd Edition

Helpful resources

Announcements
August 2022 update 768x460.jpg

Check it Out!

Click here to learn more about the August 2022 updates!

August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors