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
• 7,480 points
113 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
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
• 12,110 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
58 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 4 days ago in Power BI by CHERUKURI
• 12,780 points
6 views
0 votes
2 answers

Passing parameters to Power BI filter programmatically

In addition to @Kalgi's answer, there's another ...READ MORE

answered Sep 19, 2018 in Power BI by Nilesh
• 6,900 points
1,208 views
0 votes
1 answer

Looking for a way to to list all cloud services with their description

A jQuery selector like this should do ...READ MORE

answered Sep 21, 2018 in Power BI by Kalgi
• 35,720 points
6 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
• 12,110 points
14 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 84 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
• 35,720 points
41 views
0 votes
1 answer

Power BI Dax Multiple IF AND Statements

I suspect your issue is that alphabetically ...READ MORE

answered Oct 5, 2018 in Power BI by Kalgi
• 35,720 points
3,536 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
• 12,110 points
433 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
• 12,110 points
121 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.