Missing values on ArcGIS map visual

Hi WorkaroundLover , you can follow these steps to get the desired results :
1. Fix 1 - Force numeric non-zero bubble size
Create a defensive size measure:

Map Size Safe =
VAR v = SUM('YourTable'[ActionCount])
RETURN
IF( ISBLANK(v) || v <= 0, 1, v )

Use Map Size Safe instead of your original size field.

2. FIX 2 — Use Latitude & Longitude only

Correct configuration:

Location → Latitude

Location → Longitude

Do not include Address, City, Country together

Also:

Data category:

Latitude → Latitude

Longitude → Longitude

3. FIX 3 — Disable auto aggregation

In ArcGIS visual:

Open Map tools

Turn off:

“Enable clustering”

“Find similar locations”

Set layer to Show individual locations

4. FIX 4 — Remove NULL geography rows upstream

ArcGIS fails the entire batch if even one row has missing geo data.

Create a visual-level filter:

Latitude → is not blank

Longitude → is not blank

5. FIX 5 — Reduce address entropy

If using Address:

Create a cleaned address column:

No special characters

No extra commas

No apartment/unit text

⭐Hope this solution helps you make the most of Power BI! If it did, click 'Mark as Solution' to help others find the right answers.
💡Found it helpful? Show some love with kudos 👍 as your support keeps our community thriving!
🚀Let’s keep building smarter, data-driven solutions together!🚀  [Explore More]