Filtering with map vs filtering with slicer ¿how can I do the same?

[Galoyol84]

Hello Community,

I'm working with a report that shows the results of an indicator in 5 countries. I  used a clustered column chart to show the results and  at first (without selection) I see the acumulated results for the five countries . If I select one of them in a shape map I can see the country's contribution to the overall results, and this is very helpful as it showns in the diagram below:

Filtering with map

I would like to have the same effect when using a slicer instead of a map to select countries, but I get a different result. With the slicer I don't get to see the specific contribution of the selected country, as shown in the second diagram:

Filtering with slicer

Does anyone knows why filters work different between these two visuals (slicer vs map)? and how do I make the slicer work like the map?

Any help would be appreciated Thanks in advanced

[Anonymous · Accepted solution]

Hi @Galoyol84 

The slicer will apply the filter to the entire data set before the visualization is calculated. The map will cross filter to other visualizations, which is I believe your desired behavior.

One way to do this is not to use a slicer but use a table with "country name" as the only field. You can then click on the country name and it will cross filter.