How to Use Map Chart in Power BI

Displaying your sales by state or customer locations across the country can transform a boring spreadsheet into a powerful business insight. Power BI's map charts turn geographical data into an interactive story, making it easy to spot regional trends, opportunities, and outliers instantly. This article will guide you through creating both bubble maps and filled maps, customizing them for clarity, and using best practices to make your data compelling.

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 a Map Chart in Power BI?

In business, context is everything. Knowing where things are happening is often just as important as knowing what is happening. A table of sales figures listed by city is useful, but seeing those same figures plotted on a map reveals patterns that would otherwise stay hidden. Are sales clustering in specific regions? Is there a geographic area you’re neglecting? Are marketing campaigns in the Midwest outperforming those in the Southeast?

Map charts provide immediate answers to these location-based questions. They are perfect for:

• Visualizing Sales Performance: See which territories, states, or cities are your top performers.
• Understanding Customer Distribution: Plot your customer base to identify key geographic segments.
• Tracking Logistics and Operations: Visualize supply chain routes, warehouse locations, and operational coverage.
• Analyzing Real Estate or Site Selection: Compare property values or demographic data across different areas.

By plotting data on a map, you go beyond raw numbers and begin to understand the geographic narrative of your business.

Understanding Power BI's Map Visuals

Power BI offers several types of map visuals, each suited for different purposes. The two most common and versatile options are the standard Map and the Filled Map.

• Map (Bubble Map): This visual places circles, or "bubbles," over specific geographic points (like cities or exact addresses). The size of the bubble represents a numeric value - for example, a larger bubble for a city with higher sales. It's ideal for showing data linked to precise locations.
• Filled Map: This visual colors entire geographic areas - like countries, states, counties, or zip codes - based on a data value. The intensity of the color indicates the magnitude. For example, states with higher revenue might be a darker shade of green. It's perfect for comparing data across well-defined regions.

While Power BI also has more advanced options like Shape Maps and Azure Maps, bubble and filled maps are the go-to choices for most common business reporting needs.

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

Prepping Your Data for Mapping Visualization

Before you even click the map icon, your data needs to be ready. A map visual is only as accurate as the location data you feed it. Messy data leads to misplaced points and a confusing chart. Here’s how to set your data up for success.

1. Ensure You Have Clear Location Fields

Your dataset must contain geographic information. This can be in various formats:

• City names (e.g., "Chicago")
• State or Province names (e.g., "California")
• Country names (e.g., "United States")
• Postal or ZIP codes (e.g., "90210")
• Latitude and Longitude coordinates (for maximum precision)

2. Handle Ambiguity

Power BI uses Bing Maps to geocode your location data, which means it tries to match 'Springfield' to a real place on the map. The problem? There are dozens of Springfields in the United States alone. To avoid ambiguity, always provide more context. You'll get much more accurate results with separate columns for City, State, and Country rather than a single 'Location' column.

3. Set the Correct Data Category

This is the most critical step and one that is often overlooked. You need to tell Power BI what kind of data is in your location columns.

• Click on the Data view icon on the left-hand side of Power BI Desktop.
• Select the table containing your location data.
• Click on the column header for your location data (e.g., 'City').
• From the Column tools tab at the top, find the Data category dropdown menu.
• Select the appropriate category (e.g., City, State or Province, Country, Postal Code).

Setting the data category removes guesswork and tells Power BI exactly how to interpret a column like 'CA' (Is it Canada or California? Categorizing it as a State or Province resolves this).

Step-by-Step Guide: Creating a Bubble Map in Power BI

A bubble map is perfect for seeing how a value, like revenue or user count, is distributed across specific locations. Let's build one showing sales by city.

Step 1: Select the Map Visual

Once your data is loaded and categorized, return to the Report view. In the Visualizations pane, click the globe icon for the Map visual.

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 2: Add Your Location Data

Drag your primary location field (e.g., City) from the Data pane and drop it into the Location field well for the visual. If you have them, you can also add State and Country fields here to improve accuracy. You'll see dots appear on the map where your cities are located.

Step 3: Define the Bubble Size

Now, let's give those dots meaning. Drag a numeric measure (e.g., Sales Amount) from the Data pane and drop it into the Bubble size field. The dots on the map will immediately turn into bubbles of varying sizes, with larger bubbles representing higher sales.

Step 4: Use the Legend for Categorization (Optional)

If you have a category you want to visualize, you can use the Legend field. For example, drag a Product Category field to the Legend well. This will color-code the bubbles, instantly showing which product categories are selling in which cities.

Step-by-Step Guide: Creating a Filled Map in Power BI

A filled map is excellent for comparing performance across states, sales territories, or countries. Let's create one showing profit by state.

Step 1: Select the Filled Map Visual

In the Visualizations pane, select the icon for Filled Map (it looks like a map with shaded regions).

Step 2: Add Your Regional Data

Drag a regional field that represents a boundary (like State or Country) from your Data pane and drop it into the Location field well. Power BI will automatically draw a map highlighting the states you have data for.

Step 3: Add Your Measure to Color Saturation

To give the map its meaning, drag a numeric measure (e.g., Profit) into the Color saturation field well. The states will now be shaded based on their profit amount. By default, higher values will have a darker shade of the default color.

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

Step 4: Add Tooltips for More Detail

Drag other relevant fields into the Tooltips field well. For example, you could add Sales Amount and Total Units Sold. Now when you hover over a state, a small pop-up will show you the exact profit, sales, and units sold for that state, providing extra context without cluttering the visual.

Customizing Your Map for Better Storytelling

A default map gets the job done, but a little formatting can make your insights much clearer. Select your map visual and click the Format your visual icon (the paintbrush).

• Map settings: Here you can change the visual style of the map itself. Options include Road, Aerial, Dark, and Greyscale. A dark theme can make brightly colored bubbles pop, while a road theme can provide more context for specific city locations.
• Colors (or Bubbles): This is where you control the appearance of your data. For filled maps, you can set the minimum and maximum colors. For bubble maps, you can change the size and color of the bubbles. Consider using conditional formatting to dynamically change colors based on performance rules - for example, making bubbles red for locations with negative profit.
• Category labels: Toggling this on will display the names of the locations (e.g., state names) directly on the map. Be careful with this - it can get cluttered quickly if you have many data points.
• General (Title): Always give your chart a descriptive title. Instead of "Sum of Sales by City," try "Sales Performance by Major US Cities." A good title tells the viewer exactly what they are looking at.

Best Practices for Effective Map Charts

To create maps that are insightful instead of just decorative, keep these tips in mind:

• Don't Overcrowd the Map: Trying to plot 10,000 individual customer transactions on one map will result in an unreadable blob. Aggregate your data. Instead of raw transactions, plot total sales by ZIP code or city.
• Choose the Right Map Type: Use a bubble map for specific points (stores, airports, customer addresses). Use a filled map for comparing data across predefined regions (states, sales territories, countries).
• Use Color Meaningfully: Our brains are wired to associate colors with meaning. Use intuitive color schemes. For example, a single-color gradient (light to dark blue) is great for showing magnitude. A diverging color scheme (red-yellow-green) is perfect for showing positive and negative performance around a central point.
• Add Interactivity: Remember, you are in Power BI. Your map can be used as a filter. Clicking on a state in your filled map will filter all the other charts on your report page to show data for just that state. It's a simple way to enable deeper-dive analysis for you and your team.

Final Thoughts

Creating map charts in Power BI is a straightforward process that adds incredible value to any report. By properly preparing your location data and choosing the right visual, you can quickly identify geographic patterns and communicate a compelling story about your business's performance across different regions.

Putting together reports - especially when you need to pull sales data from Salesforce, ad performance from Google Ads, and transaction data from Shopify - often feels like a manual chore. At Graphed, we automate this entire process. You can connect all your data sources in seconds and then use simple, natural language to create dashboards and reports. Instead of grappling with data categories and field wells, you can just ask, "Show me a map of our sales by state for last quarter," and get an interactive, real-time visualization instantly.