How to Map Latitude and Longitude in Power BI

Mapping data in Power BI is a fantastic way to visualize geographic patterns, but relying on city or country names can sometimes lead to confusing results. To map precise locations like street addresses or specific branch offices, you need to use latitude and longitude coordinates. This guide will walk you through exactly how to prepare your data and create accurate, insightful maps in Power BI using latitude and longitude.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Why Use Latitude and Longitude for Maps?

While Power BI's mapping feature is excellent at recognizing locations like cities, states, and countries, it can get confused. Is that sales data from Paris, France, or Paris, Texas? If you map "Springfield," Power BI has to guess which of the dozens of Springfields around the world you mean.

Latitude and longitude coordinates remove all ambiguity. They are a universal system for identifying an exact point on Earth. By using them, you can map:

• Specific store locations or competitor outlets.
• Customer addresses for delivery route planning.
• GPS coordinates of field equipment or asset locations.
• Precise event venues or attendance data points.

Put simply, when you need pinpoint accuracy, lat/long data is the only way to go.

Preparing Your Data for Power BI

Before you can build your map, you need to make sure your data is structured correctly. Power BI has a few specific requirements for working with coordinate data.

1. Create Separate Latitude and Longitude Columns

Your dataset must have two distinct columns: one for latitude and one for longitude. You cannot have a single column with both values combined (e.g., "40.7128° N, 74.0060° W").

Here’s what a simple, correctly formatted dataset for store locations might look like in Excel or Google Sheets:

Store Name,City,Revenue,Latitude,Longitude Main Street Branch,New York,120000,40.7128,-74.0060 Downtown Outlet,Chicago,85000,41.8781,-87.6298 Ocean View Store,Los Angeles,155000,34.0522,-118.2437 Tech Park Kiosk,Austin,60000,30.2672,-97.7431

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

2. Set the Correct Data Types

Power BI needs to recognize your latitude and longitude values as numbers. When you import your data, Power BI usually does a good job of this, but it's always smart to double-check.

• Click on your Latitude column to select it.
• Go to the Column tools tab at the top.
• In the Data type dropdown menu, make sure it’s set to Decimal Number.
• Repeat this process for your Longitude column.

3. Assign Data Categories (The Most Important Step!)

This is the critical step that tells Power BI how to interpret these specific number columns. Without setting the data category, Power BI will just see two columns of numbers and won't know they represent map coordinates.

To set the data categories:

1. Select your Latitude column.
2. In the Column tools tab, click the Data category dropdown.
3. Choose Latitude from the list. You'll see a small globe icon appear next to the column name in the Data pane.
4. Now, select your Longitude column.
5. Click the Data category dropdown again and choose Longitude.

Once you see the globe icon next to both column names, your data is ready for mapping.

Step-by-Step Guide to Creating Your Lat/Long Map

With your data correctly formatted, creating the map is surprisingly simple. Let's build a map visualizing store revenue.

Step 1: Get Your Data into Power BI

First, load your dataset. From the Home ribbon, click Get data and choose your source (e.g., Excel workbook, CSV, SQL Server). Find your file and load it into your report.

Step 2: Select the Map Visual

In the Visualizations pane on the right-hand side, click on the globe icon to add a Map visual to your report canvas.

Step 3: Drag Your Fields to the Right Place

This is where your preparation pays off. Look at the fields for the Map visual in the Visualizations pane. You will see dedicated wells for Latitude and Longitude.

• From your Data pane, drag your Latitude column into the Latitude field.
• Drag your Longitude column into the Longitude field.

Just by doing this, you should see bubbles appear on the map at the exact coordinates from your data.

**Pro Tip:** Do not drag latitude or longitude into the **Location** field. This field is for text-based locations like city or state and will cause errors if you try to use coordinates there.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Step 4: Use Size to Show Importance

Right now, your map just shows where your locations are. To make it truly insightful, you need to add a measure. Let's use revenue to adjust the size of each bubble.

• Drag your Revenue field from the Data pane into the Bubble size well in the Visualizations pane.

Immediately, the bubbles will resize - larger bubbles will represent stores with higher revenue, giving you an instant visual of your top-performing locations.

Step 5: Color-Code with the Legend Field

You can add another layer of detail by color-coding the bubbles. For instance, if you have a column for "Store Type" (e.g., 'Franchise', 'Corporate'), you can use it to distinguish between them.

• Drag your Store Type column into the Legend field.

The map will now color each bubble based on the store type, and a legend will appear to explain the colors. This lets you quickly see geographic patterns, like if franchises are more common in one region than another.

Customizing and Improving Your Map

Power BI gives you plenty of options to make your map clearer and more professional. To access these, select your map visual and click the paintbrush icon (Format your visual) in the Visualizations pane.

Map Styles and Controls

• Map settings > Style: Change the background of your map. You can choose from 'Road,' 'Aerial,' 'Dark,' 'Light,' and 'Grayscale' to find a style that best fits your dashboard's theme.
• Map settings > Controls: Add an 'Auto zoom' button to frame all your data points perfectly, or enable 'Zoom buttons' (+/-) to allow users to navigate the map more easily.

Styling the Bubbles

• Bubbles: Here you can control the size of the bubbles and their transparency. If some points are too close together, you can scale down the sizes to make them more distinct.
• Bubbles > Colors: Manage the colors for your data categories. You can also turn on the 'Diverging' option and set a central, minimum, and maximum color to better highlight a continuous range, like revenue from low to high.

Troubleshooting Common Problems

Even with careful preparation, you can run into a few common issues. Here are the quickest fixes.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Problem: All My Data Points Are In the Ocean Off the Coast of Africa.

This funny-looking but frequent problem happens when Power BI plots your points at or near 0° latitude, 0° longitude. It's almost always caused by one of two things:

• Fix 1: You forgot to set the Data Category for your Latitude and/or Longitude columns. Go back to the 'Data' view and make sure both are categorized correctly.
• Fix 2: You've dragged your coordinate columns into the Location field instead of the dedicated Latitude and Longitude fields. Check your visual settings and move the fields to the right place.

Problem: My Map is Blank.

If your map shows nothing, the simplest cause is often a filter. Check the Filters pane to see if any report-level or page-level filters are unintentionally hiding your data. Also, double-check that your latitude and longitude values are correct and in a standard decimal format (e.g., negative numbers for the Western and Southern hemispheres).

Problem: My Map Only Shows One Big Bubble.

This usually occurs if Power BI is aggregating your coordinates. Right-click your Latitude and Longitude fields in the Visualizations pane and ensure they are set to Don't summarize. This tells Power BI to plot each distinct row instead of trying to average them together.

Final Thoughts

Mapping latitude and longitude in Power BI is a powerful way to transform precise geographic coordinates into actionable business insights. By ensuring your data is properly formatted and categorized, you can easily create detailed bubble maps that reveal spatial trends in sales, operations, or customer distribution at a glance.

Visualizing data in BI tools like Power BI can be incredibly effective, but creating these dashboards often requires a lot of manual setup - loading data, setting categories, and configuring each visual. At our company, we built Graphed to remove that friction. Instead of going through all these steps manually, you can simply connect your data sources and ask questions in plain English, like "show me our top stores by revenue on a map," and the visual is built for you in seconds with real-time data.