Forum Discussion
Help with Layering Reference Layer with Marker Layer (with Conditional Reference Layer Filling)
I have a geojson file of counties (includes 5 digit FIPS). a query with 5 digit FIPS that has counties and their banking desert status (either a banking desert, potential desert, or not a banking desert). I also have a numeric score column for a seperate visual (1 = not a desert, 2 = potential, 3 = banking desert). Also in that same query, I have store location data (which I want to use as "markers" or dots on the map. I have no problem with uploading the geojson file to get the county shapes in, and no problem plotting the store locations with longitude and latitude data, but I ideally want the map that I currently have (see pic below) to have the counties be filled by the legend of banking desert status. The dots are the store locations. How do I get my map to look something similar to the second photo below?
current map
ideal map
Hi W2SANC,
Thank you for reaching out to Microsoft Fabric Community.
The Azure Maps visual does not support dynamically filling GeoJSON reference layer polygons based on a field from your power bi dataset. You can either embed the fill colours directly in the GeoJSON before importing it or use a custom mapping visual if you need dynamic polygon colouring together with store location markers.
Thanks and regards,
Anjan Kumar Chippa
4 Replies
Hi W2SANC,
Thank you for reaching out to Microsoft Fabric Community.
The Azure Maps visual does not support dynamically filling GeoJSON reference layer polygons based on a field from your power bi dataset. You can either embed the fill colours directly in the GeoJSON before importing it or use a custom mapping visual if you need dynamic polygon colouring together with store location markers.
Thanks and regards,
Anjan Kumar Chippa
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:
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.
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.
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.
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
