Using Treemap as a filter

Question

So, I have this Treemap chart showing locations and I have bar charts that represent agents.

So, I want my agents to be filtered in descending order by value of money when I click on one of the locations.

For example, If I clicked on the location - Modesto. The bar chart highlights particular people(not in order). Any way to not display unhighlighted values at all or bring them all the way on a bottom?

I know we can use the slicer with locations for that, but I want Treemap act as a filter in this situation. I

Can anyone tell me if its possible? and how?

Thanks.

Answer 1

What you want is possible using the Advanced Features of the Power BI Desktop.

1. Click on treemap( turns active). 

2. You can now turn ON the Visual Interactions from the top menu bar. 

When you hover over the other visualizations on the report page, you shall notice the appearance of filter and highlight icons.

3. Select the filter symbol on the bar chart.

Hope this helps!