How to reset the pie chart mix to 100% every time when I select a category in another chart/graph?

[Anonymous]

Hi all

Can someone kindly share how to reset the pie chart mix to 100% every time when I select a category in another chart/graph? 

There are one heatmap and one pie chart on my dashboard. The hear map shows the revenue mix by different categories of app. The pie chart shows the count of those apps in different catetories. 

When I clicked one category on my heat map (e.g. "FAMILY", the biggest, light blue piece), the pie chart turned into one like below, and it seems the pie chart shows those labels show the percent of total.

However, I want the pie chart to show the mix of each category like the pie chart below in an 100% base.

Can someone kindly let me know how to do this? Thank you!

[ssugar · Accepted solution]

I think what you're looking for is to "edit interactions" between the heatmap and the pie chart. 

To do this: click on the heatmap, then go to the "Format" tab, then click on "Edit Interactions", after that, click on the filter icon above the pie chart (looks like a funnel).

This will change the interaction from the heatmap to the pie chart from the default "highlight" mode, to the "filter" mode.

This page has more detailed info on this:

http://radacad.com/control-the-interaction-in-power-bi-report

[Anonymous]

thank you so much! That is exactly what I am looking for! 

[ssugar]

no problem, happy to help 🙂