cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
chandakaushik Frequent Visitor
Frequent Visitor

Dynamically filter bar chart based on selected value on map

Hello,

 

I have a table with Country, LOB and Employee Details. I have created a map visual based on Country and a bar chart based on LOB and Count of Employees. When I click a country on Map, the bar chart should show only LOBs that are available in the selected country (no other LOBs should be displayed in bar chart). The bar chart should not display the LOBs with zero (0) headcount either.

I am able to achieve it using Country as slicer, but it doesn't work with the map. Any help?

 

Please see the screenshots below. Sri Lanka has only 1 LOB (Latam Ops). When I use slicer, it shows me only Latam Ops in bar chart with count of employees, however, if I use map, it shows all the LOBs irrespective of if the LOBs is in the country.

 

Map.png

 

map 2.png

 

2 REPLIES 2
AWA Regular Visitor
Regular Visitor

Re: Dynamically filter bar chart based on selected value on map

Hi

Have you tried to Edit Interactions under the Format window? Maybe your map is not interacting with your other visuals.

Kind regards,
Ali

chandakaushik Frequent Visitor
Frequent Visitor

Re: Dynamically filter bar chart based on selected value on map

@AWA  Interactions are ON and the map is interecting with the Bar Chart. It is however showing all the LOBs (LOBs that are not in the selected country get dimmed on the bar chart). If I replace the map with slicer, I get the intended results.

 

Bar chart should show only the LOBs that are in the selected country. If no country is selected in the map, the bar chart should show all the LOBs.

 

LOBs with zero headcount shouldn't be shown in the bar chart.

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors