Map visualizations in Power BI - Real Business Scenario

Scenario Mode

👤 Your Role: You are a sales analyst at a retail company.

📋 Request: Your manager wants to see where the highest sales are coming from across different states in the country. They want a map visualization to easily spot strong and weak sales regions.

📊 Data: You have sales data by state, including the state name, total sales amount, and number of transactions for the last quarter.

🎯 Deliverable: Create a map visualization in Power BI that shows total sales by state. Use color intensity to represent sales volume so the manager can quickly identify top-performing states.

Sample Data

State	Total Sales	Transactions
California	150000	1200
Texas	120000	950
New York	90000	800
Florida	70000	600
Illinois	60000	500
Ohio	50000	450
Georgia	45000	400
North Carolina	40000	350
Michigan	35000	300
New Jersey	30000	280

1

Step 1: Load the sales data into Power BI by importing the table with columns: State, Total Sales, Transactions.

Use 'Get Data' > 'Excel' or 'CSV' depending on your file format, then load the data into Power BI.

Expected Result

Sales data table appears in Power BI Fields pane with correct columns.

2

Step 2: Create a new map visualization on the report canvas.

From the Visualizations pane, select the 'Map' icon.

Expected Result

A blank map visual appears on the report canvas.

3

Step 3: Add the 'State' field to the Location well of the map visualization.

Drag 'State' from Fields pane to the Location field well of the map visual.

Expected Result

Map shows points or areas corresponding to each state location.

4

Step 4: Add 'Total Sales' to the Size and Color wells to represent sales volume by bubble size and color intensity.

Drag 'Total Sales' to Size and Color fields in the map visual.

Expected Result

States with higher sales show larger and darker bubbles on the map.

5

Step 5: Format the map visualization for clarity: enable data labels, set color gradient from light blue (low sales) to dark blue (high sales), and add a title 'Sales by State'.

In Format pane, turn on Data labels, set Color scale to custom gradient, and add Title text.

Expected Result

Map clearly shows sales distribution with labeled states and a descriptive title.

6

Step 6: Test the map by hovering over states to see tooltips with exact sales and transaction numbers.

Hover mouse over map bubbles to view tooltip details.

Expected Result

Tooltip shows State name, Total Sales, and Transactions for each state.

Final Result

-----------------------------------------
|           Sales by State Map           |
|                                       |
|   ● California (150k)                  |
|   ● Texas (120k)                      |
|   ● New York (90k)                    |
|   ● Florida (70k)                     |
|   ● Illinois (60k)                    |
|   ● Ohio (50k)                        |
|   ● Georgia (45k)                     |
|   ● North Carolina (40k)              |
|   ● Michigan (35k)                    |
|   ● New Jersey (30k)                  |
|                                       |
|  (Bubble size and color show sales)   |
-----------------------------------------

✓California has the highest sales with 150,000 total sales.

✓Texas and New York follow as strong sales states.

✓Southern and Midwestern states have moderate sales.

✓The map visualization helps quickly identify top and low sales regions.

Bonus Challenge

Add a slicer to filter the map by transaction count ranges (e.g., 0-500, 501-1000, 1001+).

Show Hint

Create a calculated column to categorize transactions into ranges, then add a slicer visual using that column.