Help with Layering Reference Layer with Marker Layer (with Conditional Reference Layer Filling)

Hi User,

You can achieve this by using separate map layers in Power BI, with the county GeoJSON as the reference layer and the store locations as the marker layer.

A recommended approach:

1. Create the county boundary layer

• Load your GeoJSON file as the reference layer.

• Make sure the county identifier (5-digit FIPS code) exists in both your GeoJSON data and your banking desert dataset.

• Create a relationship between the GeoJSON county table and your banking desert status table using the FIPS code.

1. Apply conditional filling to counties

• Add your Banking Desert Status field to the reference layer's legend/category field.

• Use the three categories:

  • Not a Banking Desert

  • Potential Desert

  • Banking Desert

• Configure the reference layer fill colors based on those categories.

1. Add store locations as a separate marker layer

• Use your latitude and longitude fields for the store locations.

• Add the store table as the point/marker layer.

• Keep the marker layer above the county reference layer so the dots remain visible.

1. Avoid using the numeric score directly for coloring
   Since your score column is only for ordering or analysis, use the text category field for the map legend. You can still keep the numeric score as a sort column if needed.

If you are using the Azure Maps visual, you can configure this through:

• Reference layers → Add GeoJSON layer

• Data fields → Match your FIPS column

• Layer settings → Fill color / Transparency

• Bubble layer → Store locations

For more information:

• Azure Maps visual in Power BI: https://learn.microsoft.com/power-bi/visuals/power-bi-visualization-azure-maps-visual-overview

• Add reference layers to Azure Maps: https://learn.microsoft.com/power-bi/visuals/power-bi-visualization-azure-maps-format-layers

Could you also confirm:

• Are you using the Azure Maps visual or the older Map/Shape Map visual?

• Does your GeoJSON contain the FIPS code as a property field?

• Are you trying to make the map dynamic based on slicers (year, region, etc.)?

The exact setup depends on which map visual you are using.

💡 Helpful? Give a Kudos 👍 — keep the community growing.

✅ Solved your issue? Mark this as the Accepted Solution ✔️

Best regards,
Prince Singh | Data Science & Microsoft Fabric Enthusiast