Workarounds and Solutions

🔹 1. Use a “Category” Legend and Transparency

Ensure your Legend field is assigned to your category column
This allows Azure Maps to color-code the overlapping bubbles
Also set Bubble Opacity in the Format pane (under "Layer" or "Bubble Layer") to something like 30–50%

✅ Benefit: Bubbles appear blended or layered with different colors, making overlaps more visible.

2. Add a Small Offset to Coordinates (Jittering)

Introduce small variations in the coordinates (called jittering) to space out overlapping points visually.

You can do this with calculated columns like:

LatitudeAdjusted = [Latitude] + (RANDBETWEEN(-5,5) * 0.0001)
LongitudeAdjusted = [Longitude] + (RANDBETWEEN(-5,5) * 0.0001)

Benefit: Slight position shifts create a “cloud” of dots around the actual location, allowing visual separation.
⚠ Use cautiously — you’re distorting geo-location slightly for visualization purposes.

Use a Cluster Layer Instead

If you're displaying many overlapping points, you might switch to Clustering (if available in your Azure Maps visual settings):

Go to Format Pane > Layers > Cluster Layer

Enable clustering and set bubble size based on count

✅ Benefit: You won’t see individual overlapping points, but you’ll see summary clusters with tooltips showing breakdown by category.

Tooltip Drillthrough

Use tooltip pages or report drillthrough functionality:

When users hover or right-click a bubble, offer a drillthrough to a table or detailed page listing all overlapping records for that location

✅ Benefit: Gives exact detail even if the bubbles are visually stacked
❌ Doesn’t improve the immediate visual, but improves analysis usability

5. Switch to Icon Layer or Heatmap

If your use case allows:

Use Icons instead of bubbles (e.g., different shapes)

Or apply a heatmap layer to show density across the same coordinate

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!

Workarounds and Solutions

🔹 1. Use a “Category” Legend and Transparency

2. Add a Small Offset to Coordinates (Jittering)

Use a Cluster Layer Instead

Tooltip Drillthrough

5. Switch to Icon Layer or Heatmap

Forum Discussion

Top N, others and null values

Handling Null Values

Counting nulls

Null value error

Replace Values Null to Blank or Blank to Null

Unpivot other columns with null values