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,490 points
228 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,270 points

Related Questions In Power BI

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,190 points
122 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 in Power BI by Cherukuri
• 17,890 points
18 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 in Power BI by Avantika
• 1,500 points
31 views
0 votes
1 answer

How do I add a filter and a slicer?

Hi, Its OLTP and DW modeling. However, you ...READ MORE

answered May 22 in Power BI by Avantika
• 1,500 points

edited May 23 by Omkar 22 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 in Power BI by Shubham
• 13,270 points
40 views
+3 votes
2 answers

Combine tables in Power BI

You can also achieve this using a ...READ MORE

answered Oct 5, 2018 in Power BI by lina
• 8,100 points

edited Oct 11, 2018 by Kalgi 114 views
0 votes
1 answer

Power Bi Dax Table

You need to wrap the numbers in ...READ MORE

answered Oct 5, 2018 in Power BI by Kalgi
• 37,560 points
54 views
0 votes
2 answers

Power BI Dax Multiple IF AND Statements

HI I have Column Patient 12 13 14 15 18 IN Patient=12, 13 Out ...READ MORE

answered May 22 in Power BI by VNK
5,700 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,270 points
668 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 in Power BI by Shubham
• 13,270 points
311 views