Ignore filter on Azure map visual

[KMalik]

Hi everyone,

I have a slicer for countries on page 1 and it applies to all pages on my dashboard. However, I don't want it applied just on an azure map visual on one of the pages. I have a filled map with Country in Location, Latitude, Longitude and just a categorical variable in Legend fields and I have applied different colours to different categories.

I have tries edit interactions but it only shows the filter Country applied on the Azure map but does not give me the "none" icon. 

Thanks heaps for your help.

[Kedar_Pande · Accepted solution]

@KMalik 

Create a new measure that removes the slicer context from the Country filter using ALL in DAX.

Country_Ignored_Measure = 
CALCULATE(SUM('YourTable'[YourMetricColumn]), ALL('YourTable'[Country]))

Replace 'YourTable'[YourMetricColumn] with the actual table and metric you’re plotting on the map.

💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn

[KMalik]

Thanks for your reply.

I have a legend variable which is a text variable as has values like "100-150", "150-200" and so on and I assign colors based on those categories. I am unable to use the measure in the legend field.

[Bibiano_Geraldo]

HI @KMalik ,

You need to disable interactions between your slicer and Azure map visual, to achieve this, please follow these steps:

1. Select your slicer

2. Go to Format Tab

3. Click on Edit interactions

4. Set interations to none in your azure map visual.

Here go the picture to help you:

I hope this help you, if so, please give a Kudo and Accept this reply as solution.

thank you.

[KMalik]

Thanks for your reply but edit intercations does show the "none" option on my map and just shows the filter applied. That's  why looking for an alternate solution. Thanks

[Anonymous]

Thanks for the reply from Bibiano_Geraldo  and Kedar_Pande , please allow me to provide another insight:

Hi, @KMalik 

Typically, to remove filters, you can directly use the DAX functions REMOVEFILTERS() or ALL().
 For further details, please refer to:

REMOVEFILTERS function (DAX) - DAX | Microsoft Learn
ALL function (DAX) - DAX | Microsoft Learn
 

However, considering that the legend in your visualisation does not apply to the measure, the alternative solution we can currently propose is to change your page-level filters to visual-level filters.
This involves adding filters individually to each visualisation.

For more details, please refer to:

 Add a filter to a report in Power BI - Power BI | Microsoft Learn

Of course, if you have any new discoveries or questions, please feel free to get in touch with us.
 

Best Regards,

Leroy Lu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
 

[Bibiano_Geraldo]

Thank you for your reply, in this case i think that @Kedar_Pande  solution its great for you.