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

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

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.