How to Use Map Visual in Power BI

Adding a map to a report isn’t just for looks, it’s one of the clearest ways to show how location impacts your business. From tracking regional sales to understanding where your website visitors are coming from, Power BI’s map visuals turn bland lists of cities and countries into valuable business insights. This article will walk you through how to prepare your data, create different types of maps, and customize them to tell a compelling story.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Why Use Maps in Your Power BI Reports?

Before jumping into the "how," let's quickly cover the "why." Geographic data is everywhere in business, but putting it in a table or a bar chart doesn't always cut it. Maps provide immediate context that numbers alone can't.

Imagine you're analyzing sales data for a retail company. A bar chart might show you that California has the highest sales, but a map can show you so much more. You can instantly see clusters of high performance, identify underserved regions, or notice that sales are concentrated along major highways. This kind of visual analysis helps stakeholders instantly grasp regional trends and make smarter, location-based decisions.

Here are a few common scenarios where maps are incredibly effective:

• Sales Performance: Visualizing sales revenue or profit by state, country, or even zip code.
• Marketing Campaigns: Tracking website traffic, sign-ups, or social media engagement by geographic region.
• Operations & Logistics: Plotting a network of warehouse locations, supplier addresses, or delivery routes.
• Customer Demographics: Mapping where your customers live to better understand your target audience and plan new store openings.

Preparing Your Data for Map Visuals

The "garbage in, garbage out" rule applies here. Power BI is smart, but it needs clean and clear location data to create an accurate map. The most common hiccup people encounter is poorly formatted data, so spending a few minutes here will save you a lot of headaches later.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Required Location Data

Power BI can interpret several types of geographic information, including:

• Country or Region (e.g., "United States", "Germany")
• State or Province (e.g., "Texas", "British Columbia")
• City (e.g., "London", "Tokyo")
• Postal/Zip Code (e.g., "90210", "SW1A 0AA")
• Street Address (e.g., "1600 Pennsylvania Avenue NW, Washington, DC")
• Latitude and Longitude: These specific coordinates are the most precise way to plot data and avoid any ambiguity.

The Importance of Context

One of the biggest pitfalls is ambiguity. For example, there are over 30 cities named "Paris" worldwide. If your dataset only has a "City" column with "Paris" as a value, how does Power BI know whether to plot a point in France or in Texas?

To solve this, always provide context. If you have city data, make sure you also have columns for State/Province and Country. By giving Power BI all three — City, State, and Country — you eliminate the guesswork and ensure your locations are plotted correctly.

Here’s an example of a well-structured dataset:

Setting the Data Category

After loading your data, it's a good practice to tell Power BI exactly what kind of data is in each column. This helps its mapping engine, Bing Maps, interpret your information with higher accuracy.

1. Navigate to the Data view (the grid icon on the left-hand pane).
2. Select the table and click on the column header you want to categorize (e.g., your 'Country' column).
3. The Column tools tab will appear in the top ribbon.
4. Click on the Data category dropdown and select the appropriate category (e.g., "Country", "State or Province", "City", etc.).

Repeat this for all your geographic columns. It's a small step that significantly improves the reliability of your map visuals.

How to Create a Standard Map Visual (Step-by-Step)

Now for the fun part. Let's create a "bubble map," where the size of each circle (or bubble) on the map represents a specific metric.

We'll use a simple dataset of sales by US state for this example.

1. Open Power BI and Load Data: Start a new report and import your dataset.
2. Select the Map Visual: In the Visualizations pane on the right, click the globe icon for the standard Map. A blank map placeholder will appear on your report canvas.
3. Add Your Location Data: From the Data pane, drag your main location field (e.g., 'State') and drop it into the Location field well in the Visualizations pane. You'll see small, uniform dots appear on the map for each state in your data.
4. Size the Bubbles: Now, let's make this map useful. Drag the metric you want to measure (e.g., 'Sales') and drop it into the Bubble size field well. The dots on the map will instantly change size, with larger bubbles representing states with higher sales.
5. Enrich with Tooltips (Optional but Recommended): Drag any other relevant data points into the Tooltips well. For example, adding 'Profit' and 'Number of Orders' allows you to see those details when you hover over a state's bubble.

That's it! In just a few clicks, you’ve turned a simple table into an intuitive visual that clearly shows your top-performing regions at a glance.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Customizing and Formatting Your Map

A default map is good, but a well-formatted map is great. You can customize nearly every aspect of your map’s appearance to match your brand and make the data even clearer.

With your map selected, click the paintbrush icon (Format visual) in the Visualizations pane.

Key Formatting Options

• Map settings > Style: Change the background theme of the map. You have options like Road, Aerial, Dark, Light, and Greyscale. A dark or greyscale map can make your colorful data bubbles pop.
• Bubbles: Here, you can change the color of all bubbles or use conditional formatting. Click the fx button next to Colors to set rules. For example, you can create a gradient where low sales values are red and high values are green. You can also adjust the transparency and scale of the bubbles.
• Category labels: Toggle this 'on' to display the names of the locations (e.g., 'California', 'Texas') directly on the map. This can get cluttered on dense maps but is helpful for regional overviews.
• Map controls: Enable Zoom buttons to give users an easier way to zoom in and out of the map without relying on a mouse scroll wheel.

Exploring Other Map Types in Power BI

While the standard bubble map is a great starting point, Power BI offers other map visuals for different scenarios.

1. Filled Map (Choropleth)

Instead of showing bubbles, a Filled Map colors entire regions (like states, countries, or counties) based on a data value. This is excellent for visualizing data like population density, election results, or sales concentrations where you want to shade a whole area.

To create one, just click the Filled map visual in the Visualizations pane (it looks like a shaded map) and follow the same steps as the bubble map, dragging your location to the Location well and your metric to the now-available Color saturation well.

2. Shape Map

The Shape Map is more specialized. It allows you to use custom map regions that aren't standard geographic boundaries. For instance, you could show sales broken down by your company’s unique sales territories or visualize foot traffic in different sections of a store floor plan.

This is a preview feature you may need to enable in File > Options and settings > Options > Preview features. It often requires specific custom map files (in a format called TopoJSON), making it a more advanced choice for specific use cases.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

3. ArcGIS Maps for Power BI

If you need serious mapping power, the ArcGIS Maps visual integrates advanced geographic information system (GIS) capabilities directly into Power BI. It allows for things like adding demographic layers, plotting heat maps, finding locations within a certain drive time, and much more. It's a powerful tool designed for deep geographic analysis.

Final Thoughts

Maps are a fantastic tool for transforming your geographical data into clear, actionable insights within Power BI. By starting with clean, well-structured data and choosing the right visual, you can uncover regional trends and tell compelling stories that raw numbers could never convey.

Of course, getting that clean, centralized data is often the hardest part, especially when your information is scattered across a dozen different platforms. That’s why we built Graphed to help. We connect directly to your data sources - like Shopify, Google Analytics, Salesforce, or Facebook Ads - so you get one unified view of your business. Instead of manually exporting CSVs and fighting with data formatting, you can just ask a question like, “Show me a map of our sales from Shopify vs. website sessions from Google Analytics by state this year,” and get a live, interactive dashboard in seconds that you can share with your team.