How to Create Map Visual in Power BI: Step-by-Step Guide

To create a map visual in Power BI, add a Map visual from the Visualizations pane, then drag your location fields (like city, state, or latitude/longitude) into the Location well. Customize the map by adding data to Size or Color saturation to show values on the map.

Syntax

In Power BI, creating a map visual involves selecting the Map visual and assigning data fields to specific roles:

• Location: Geographic data like city, country, or coordinates.
• Latitude and Longitude: Optional precise coordinates for better accuracy.
• Size: Numeric value to control bubble size on the map.
• Color saturation: Numeric value to control color intensity.

This setup lets Power BI plot your data points on a map automatically.

plaintext

1. Open Power BI Desktop.
2. Click on the Map visual icon in the Visualizations pane.
3. Drag a geographic field (e.g., City) to the Location bucket.
4. (Optional) Drag numeric fields to Size or Color saturation buckets.
5. Adjust map settings as needed.

Output

A map visual appears on the report canvas showing data points based on your location data.

Example

This example shows how to create a map visual using sample sales data with city names and sales amounts.

plaintext

1. Load your data with columns: City, Sales.
2. Select the Map visual from the Visualizations pane.
3. Drag the <code>City</code> field to <code>Location</code>.
4. Drag the <code>Sales</code> field to <code>Size</code>.
5. The map will display bubbles sized by sales amount at each city location.

Output

A map with bubbles over cities, where bubble size reflects sales volume.

Common Pitfalls

• Incorrect location data: Using ambiguous or misspelled place names can cause map points to not appear or be misplaced.
• Missing latitude/longitude: For better accuracy, use coordinates if city or region names are not unique.
• Overlapping bubbles: Large bubbles can overlap and hide data; consider using filters or smaller size scales.
• Not setting data categories: Make sure location fields are categorized correctly as City, State, or Country in the data model.

plaintext

Wrong:
Drag a numeric field to Location bucket (e.g., Sales) - map will not show locations.

Right:
Drag a geographic field (e.g., City) to Location bucket.

Quick Reference

Map Visual Role	Description	Example Field
Location	Geographic data to plot points	City, Country, Address
Latitude	Latitude coordinate for precise location	34.0522
Longitude	Longitude coordinate for precise location	-118.2437
Size	Numeric value controlling bubble size	Sales Amount
Color saturation	Numeric value controlling color intensity	Profit Margin

Key Takeaways

Always use clear geographic fields like city or coordinates in the Location bucket.

Add numeric fields to Size or Color saturation to visualize data magnitude on the map.

Check and categorize your location data correctly to avoid mapping errors.

Use filters or adjust bubble sizes to prevent overlapping data points.

Customize map settings for better clarity and user experience.