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

Filter a map after two slicers are selected

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Filter a map after two slicers are selected

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:

1.PNG

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

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Community Support Team
Community Support Team

Re: Filter a map after two slicers are selected

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:

1.PNG

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

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
marcoslepore Frequent Visitor
Frequent Visitor

Re: Filter a map after two slicers are selected

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