Distance-Based Location Highlighting

Hi Swami_om​,

If you already have the distance calculation working, then I would separate the remaining requirement into a colour measure.

The important part is to give the selected location the highest priority, then check the distance, and finally use grey for everything else.

For example, if StoresDummy[City] is your disconnected slicer table:

Location Color =
VAR SelectedCity =
    SELECTEDVALUE ( StoresDummy[City] )

VAR CurrentCity =
    SELECTEDVALUE ( Locations[City] )

VAR DistanceKm =
    [Distance KM]

VAR SelectedRadiusKm =
    [Selected Distance KM]

RETURN
    SWITCH (
        TRUE (),
        NOT ISBLANK ( SelectedCity )
            && CurrentCity = SelectedCity, "#D32F2F",
        NOT ISBLANK ( DistanceKm )
            && DistanceKm <= SelectedRadiusKm, "#2E7D32",
        "#BDBDBD"
    )

You would replace Locations[City], [Distance KM], and [Selected Distance KM] with the corresponding names from your model.

The order of the conditions is important. The selected city is tested first, so even though its distance would normally be 0 km and therefore qualify as green, it is returned as red instead.

Microsoft recommends SELECTEDVALUE for retrieving a single selected slicer value, and Power BI supports using a DAX measure that returns hex colours for field-value conditional formatting.

I would also keep StoresDummy disconnected from the location table if it is being used only to select the centre location. If you use the same City field that drives the map as the slicer, selecting a city can filter the other map locations away, which prevents you from showing the surrounding locations in green/grey.

Then apply Location Color to the map's marker/fill colour using conditional formatting (fx) with Format style = Field value, if the map layer you are using exposes that option.

The resulting logic is:

• selected location = red
• location within selected radius = green
• location outside selected radius = grey

If you are using Azure Maps specifically, the exact colour setting depends on whether you are using the Marker, Filled map, or another layer, but the DAX logic above can remain the same.

AI-assisted drafting: AI was used to help structure and phrase this response. I reviewed and validated the technical content before posting.