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...
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

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

  • Bibiano_Geraldo's avatar
    Bibiano_Geraldo
    Super User
    1 year ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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.