Maps and Geographic Visuals
Maps and geographic visuals help users understand business performance across locations. In Power BI, geographic information can be used to compare regional sales, analyze customer distribution, identify location-based patterns, and support decisions involving territories.
Learning Objectives
- Understand the purpose of geographic visuals.
- Prepare location fields for map visualizations.
- Understand bubble maps, filled maps, and Azure Maps.
- Configure location, size, color, and tooltip fields.
- Recognize common geographic data quality problems.
- Choose appropriate map visuals for business analysis.
1. What Are Geographic Visuals?
Geographic visuals display data using location information such as country, state, city, postal code, latitude, and longitude. These visuals allow users to explore where business activities occur.
Example: Regional Business Analysis
Markers can represent locations, while their sizes or colors can represent measures such as sales, orders, or customer counts.
2. Common Map Visual Types
| Visual Type | Purpose | Example |
|---|---|---|
| Bubble Map | Shows locations with markers | Sales by city |
| Filled Map | Colors geographic regions | Sales by state |
| Azure Maps | Supports geographic layers and location analysis | Store distribution |
| Shape Map | Displays values using supported geographic shapes | Regional performance comparison |
3. Bubble Maps
A bubble map places markers at geographic locations. Marker size, color, and tooltips can communicate additional business information. Bubble maps are useful for comparing measures across cities, stores, branches, and other point locations.
Illustration: Sales by City
How to Build a Bubble Map
- Select a supported map visual in Power BI Desktop.
- Add a geographic field such as City or State to the location field.
- Add a measure such as Total Sales to the size field, if supported by the selected visual.
- Optionally add a category field to the legend.
- Add useful fields to tooltips.
- Verify that each marker appears at the correct location.
4. Filled Maps
Filled maps color geographic regions according to a measure or category. They are useful when the business question concerns differences between countries, states, provinces, or other supported geographic areas.
Illustration: Regional Sales Intensity
How to Create a Filled Map
- Choose a supported filled-map visual.
- Add a geographic region field to the location field well.
- Add a numeric measure to the color or value field, where supported.
- Configure the color scale and legend.
- Review the region boundaries and verify that locations are matched correctly.
5. Azure Maps and Geographic Layers
Azure Maps is a mapping visual available in supported Power BI environments. Depending on the current implementation and available settings, it can support different ways to represent geographic data, including point layers and other location-focused visualizations.
Geographic Layer Concept
Typical Business Uses
- Visualizing store and branch locations.
- Exploring customer distribution by geography.
- Comparing sales performance across territories.
- Displaying delivery or service coverage.
- Supporting location-based operational planning.
6. Prepare Geographic Data Correctly
Geographic visuals depend on accurate location fields. Incorrect spellings, inconsistent labels, missing values, and ambiguous names can cause locations to appear incorrectly or remain unmatched.
| Field | Example | Purpose |
|---|---|---|
| Country | India | Provides country context |
| State | Maharashtra | Identifies a state or province |
| City | Pune | Identifies a city or locality |
| Latitude | 18.5204 | Specifies north-south position |
| Longitude | 73.8567 | Specifies east-west position |
7. Assign Geographic Data Categories
Power BI can use data categories to interpret certain fields as geographic information. Where appropriate, select the relevant column and assign a category such as Country/Region, State or Province, City, Postal Code, Latitude, or Longitude.
- Open Data view or Model view.
- Select the geographic column.
- Locate the data category setting in the column properties.
- Choose the category that matches the actual contents of the column.
- Return to the report and verify the map's location matching.
8. Map Formatting and Tooltips
Map formatting helps users interpret geographic patterns without creating unnecessary visual clutter.
- Use a descriptive title that states the measure and geography.
- Choose marker sizes that keep nearby locations distinguishable.
- Use a clear color scale with an understandable legend.
- Add useful tooltip fields such as region, sales, and order count.
- Keep labels readable and avoid overlapping information.
- Check the visual at different zoom levels.
Example Tooltip Design
Tooltips provide additional information when users hover over supported map elements. Use fields that help explain the location's business performance.
9. Common Map Problems
| Problem | Possible Cause | Recommended Check |
|---|---|---|
| Location appears in the wrong place | Ambiguous place name | Add country or state context |
| Some locations are missing | Blank or invalid location values | Inspect and clean the source data |
| Markers have unexpected sizes | Incorrect aggregation or measure | Verify the field and aggregation |
| Map is difficult to read | Overlapping markers or excessive labels | Adjust zoom, sizing, and labels |
| Map visual is unavailable | Visual or tenant restrictions | Check Power BI environment settings |
10. Practice Activity
Scenario: Regional Store Performance
Imagine that a retail company operates branches in several cities. The dataset contains the following fields:
| City | State | Country | Total Sales | Total Orders |
|---|---|---|---|---|
| Pune | Maharashtra | India | 125,000 | 320 |
| Mumbai | Maharashtra | India | 180,000 | 450 |
| Nashik | Maharashtra | India | 85,000 | 210 |
| Nagpur | Maharashtra | India | 95,000 | 240 |
Tasks
- Create a map that displays each city as a location.
- Use Total Sales to represent the value of each location where supported.
- Add Total Orders and State to the tooltips.
- Verify that all cities are placed correctly.
- Compare a point-based map with a suitable regional map.
- Write two observations about the sales distribution.
11. Knowledge Check
Question 1: Which fields can help identify a geographic location?
A. City, State, and Country
B. Font Size and Border Color
C. Page Title and Theme Name
Question 2: What does a filled map typically emphasize?
A. Geographic regions colored by values or categories
B. Individual text paragraphs
C. DAX formula syntax
Question 3: What should you do when a city name is ambiguous?
A. Add geographic context such as country or state
B. Remove all location fields
C. Change the report font
Show Answers
- Question 1: A — City, State, and Country.
- Question 2: A — Geographic regions colored by values or categories.
- Question 3: A — Add geographic context such as country or state.
Summary
In this lesson, you learned how geographic visuals represent business information by location. You explored bubble maps, filled maps, and Azure Maps, and practised assigning location fields, configuring measures, and adding useful tooltips.
Accurate geographic data, suitable visual selection, and clear formatting are essential for reliable map analysis. Validate location matching and measure aggregation before using geographic visuals to support business decisions.