Filter a map after two slicers are selected

[marcoslepore]

Hi All, I am creating a report and I have a map with some facilities. But those facilities change the location each month and year. 

Store A in january 2017 is located in a specific latitude and longitude. Then, on january 2018 it is located in another coordinates.

So, when I creat the map, I created two slicers one with a year and other with a month. So the client can have a "picture" of the map in the selected month and year. But I have a problem: when the person selects January, not selecting any Year, it appears 2 "Store A" on the map (the one related to 2017 and the one related to 2018).

I was wondering if I can select January without filtering the map. Could the map just be filtered after the two slicers are selected?

Thanks.

[v-danhe-msft · Accepted solution]

Hi @marcoslepore,

Based on my test, I am afraid you could not achieve this feature currently, I suggest you to use the "Hierarchy Slicer", it could help you to fix the month at the related year to filter the data:

Reference: https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380820?src=office&tab=Overview

Regards,

Daniel He

[marcoslepore]

@v-danhe-msft Thanks for the suggestion. I´ll try this. Unfortunately the map will be filtered anyway. Thanks!