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

[chandakaushik]

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.

[MFelix · Accepted solution]

Hi @chandakaushik ,

You must use the edit interactions to change the way your visuals filter out other visuals.

Check the documentation on the link below:

https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions

Regards,

MFelix

[chandakaushik]

@MFelix  Thanks dear! I was making a very silly mistake with the interactions. This Microsoft documentation helped. Thank you for sharing!! 🙂