Forum Discussion

KMalik's avatar
KMalik
Frequent Visitor
1 year ago
Solved

Ignore filter on Azure map visual

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.

Need Help
  • Kedar_Pande's avatar
    Kedar_Pande
    1 year ago

    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

6 Replies

  • Bibiano_Geraldo's avatar
    Bibiano_Geraldo
    Super User
    1 year ago

    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's avatar
      KMalik
      Frequent Visitor
      1 year ago

      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

  • Kedar_Pande's avatar
    Kedar_Pande
    Super User
    1 year ago

    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's avatar
      KMalik
      Frequent Visitor
      1 year ago

      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.