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
4,421 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,490 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, 2020 in Power BI by Rakesh
5,743 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,160 points
4,169 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
• 33,030 points
640 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,520 points
1,384 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,490 points
2,164 views
0 votes
1 answer
0 votes
1 answer

Left Outer Join using DAX in PowerBI.

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

answered Sep 24, 2020 in Power BI by Gitika
• 65,890 points
1,585 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, 2020 in Power BI by Alisha
6,164 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,490 points
4,932 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,490 points
7,059 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP