Using Treemap as a filter

0 votes
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.
Dec 17, 2018 in Power BI by Upasana
• 8,620 points
1,478 views

1 answer to this question.

0 votes

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!

answered Dec 17, 2018 by Shubham
• 13,450 points

Related Questions In Power BI

0 votes
1 answer

By default, which level of filter behaves as same as a slicer in a report in Power BI desktop?

Hey, There are several types of filters in ...READ MORE

answered Jan 31 in Power BI by Rakesh
1,480 views
0 votes
1 answer

Excel Power Query: Using List.MatchAny on a column value

try this. let TableA = ...READ MORE

answered Oct 22, 2018 in Power BI by Annie97
• 2,200 points
1,525 views
0 votes
1 answer

Can i show data for one variable for a field without using slicer?

Hi Pranav, Yes, you can perform the calculation ...READ MORE

answered May 16, 2019 in Power BI by Cherukuri
• 32,490 points
114 views
0 votes
1 answer

How do you add a new filter pane in old Power BI reports?

Hi, You can perform the following steps: 1. Open ...READ MORE

answered May 22, 2019 in Power BI by avantika
• 1,500 points
601 views
0 votes
1 answer

To calculate conditional running total in power query

Try Table Buffer after adding the index, or ...READ MORE

answered Apr 26, 2019 in Power BI by Shubham
• 13,450 points
930 views
0 votes
1 answer

Left Outer Join using DAX in PowerBI.

You can simply write a few measures ...READ MORE

answered Sep 24 in Power BI by Gitika
• 41,120 points
30 views
0 votes
1 answer

How to get month name from month number in Power BI?

You can use: MonthName = FORMAT(DATE(1, [Num], 1), ...READ MORE

answered Sep 24 in Power BI by Alisha
25 views
0 votes
1 answer

Embedding a dashboard using Java in Power BI

Make sure to use the correct embedURL, ...READ MORE

answered Nov 30, 2018 in Power BI by Shubham
• 13,450 points
1,856 views
0 votes
1 answer

Calculating MoM Variance of a Measure Field using DAX

Create an intermediate calculated column that considers ...READ MORE

answered Feb 28, 2019 in Power BI by Shubham
• 13,450 points
4,016 views