Forum Discussion

chandakaushik's avatar
6 years ago
Solved

Dynamically Filtering Bar Chart based on Selected Value on Map [No Zeros, No Grand Totals]

Hello,

 

I have a table containing Country, LOB and Employee Details. I have created a map based on Country and a Bar Chart based on LOB and Count of Employees.  

 

Based on the Selected country on the map, the Bar chart should only show the LOBs in that country and should not show LOBs with 0 (zero) headcount. Example, Sri Lanka has only  1 LOB. When Sri Lanka is selected on the map, the bar chart should only show Latam Ops with count of employees in that LOB.  It is working for me if I use a slicer instead of map, but isn't working if I use a map to filter the other visual.

 

2 Replies