Map visualizations in Power BI - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to add a map visualization showing sales by country.

Power BI

Map = SUMMARIZE(Sales, Sales[Country], "TotalSales", [1](Sales[Amount]))

Drag options to blanks, or click blank then click option'

AAVERAGE

BCOUNT

CSUM

DMIN

Attempts:

3 left

💡 Hint

Common Mistakes

Using COUNT instead of SUM

Using AVERAGE which gives average, not total

We use SUM to add up sales amounts by country for the map.

2fill in blank

medium

Complete the code to filter map data to only show sales from 2023.

Power BI

FilteredMap = FILTER(Sales, Sales[Year] = [1])

Drag options to blanks, or click blank then click option'

A2023

B2021

C2024

D2022

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing a wrong year

Using a string instead of a number

We filter for the year 2023 to show only that year's sales on the map.

3fill in blank

hard

Fix the error in the DAX measure to calculate total sales for the map.

Power BI

TotalSales = CALCULATE([1](Sales[Amount]), ALL(Sales[Region]))

Drag options to blanks, or click blank then click option'

ASUM

BAVERAGE

CMIN

DCOUNT

Attempts:

3 left

💡 Hint

Common Mistakes

Using COUNT which counts rows

Using AVERAGE which averages values

The SUM function correctly totals the sales amount ignoring region filters.

4fill in blank

hard

Fill both blanks to create a measure that calculates sales growth percentage for the map.

Power BI

SalesGrowth = DIVIDE(SUM(Sales[Amount]) - SUM(Sales[Amount])[1] 1, SUM(Sales[Amount])[2] 1)

Drag options to blanks, or click blank then click option'

A-

B+

C/

D*

Attempts:

3 left

💡 Hint

Common Mistakes

Using plus instead of minus

Using multiplication or division incorrectly

We subtract last year's sales ({{BLANK_1}}) and divide by last year's sales ({{BLANK_2}}) to get growth.

5fill in blank

hard

Fill all three blanks to create a map measure that shows average sales per city filtered by region.

Power BI

AvgSalesCity = CALCULATE([1](Sales[Amount]), FILTER(Sales, Sales[Region] [2] [3]))

Drag options to blanks, or click blank then click option'

AAVERAGE

B=

C"West"

D>

Attempts:

3 left

💡 Hint

Common Mistakes

Using SUM instead of AVERAGE

Using wrong comparison operators

Missing quotes around region name

We calculate the AVERAGE sales amount, filtering where region equals "West".

Practice

1. What is the main purpose of a map visualization in Power BI?

easy

A. To create pie charts for categorical data

B. To show data by location and reveal geographic patterns

C. To display only numerical trends over time

D. To filter data based on user input

Solution

1. Step 1: Understand map visualization purpose

   Map visuals display data points on a geographic map to show location-based patterns.

2. Step 2: Compare options with map use

   Only To show data by location and reveal geographic patterns describes showing data by location and geographic patterns, which matches map visuals.

3. Final Answer:

   To show data by location and reveal geographic patterns -> Option B

4. Quick Check:

   Map visuals = geographic data display [OK]

Hint: Maps always show data by location and geography [OK]

Common Mistakes:

• Confusing map visuals with charts for trends
• Thinking maps only show numbers without location
• Mixing map visuals with filtering tools

2. Which of the following is the correct way to assign fields in a Power BI map visualization?

easy

A. Assign a numeric field to Location and a geographic field to Size

B. Assign a text field to Size and a numeric field to Location

C. Assign a date field to Location and a text field to Size

D. Assign a geographic field to Location and a numeric field to Size or Color

Solution

1. Step 1: Recall field roles in map visuals

   Geographic fields (like city, country) go to Location; numeric fields (like sales) go to Size or Color.

2. Step 2: Match options with correct field assignment

   Only Assign a geographic field to Location and a numeric field to Size or Color correctly assigns geographic fields to Location and numeric fields to Size or Color.

3. Final Answer:

   Assign a geographic field to Location and a numeric field to Size or Color -> Option D

4. Quick Check:

   Location = geographic, Size/Color = numeric [OK]

Hint: Location needs geography; Size/Color needs numbers [OK]

Common Mistakes:

• Putting numbers in Location field
• Assigning text fields to Size
• Confusing date fields with geographic fields

3. Given a dataset with sales by city, what will happen if you create a map visual with City in Location and Sales in Size?

medium

A. The map will show bubbles sized by sales amount at each city location

B. The map will show a heatmap with colors representing sales

C. The map will show a table of sales values without geographic points

D. The map will produce an error because Size cannot be numeric

Solution

1. Step 1: Understand field roles in map visual

   City is geographic, so it sets the location; Sales is numeric, so it controls bubble size.

2. Step 2: Predict map output

   The map will display bubbles on each city sized proportionally to sales amount, matching The map will show bubbles sized by sales amount at each city location.

3. Final Answer:

   The map will show bubbles sized by sales amount at each city location -> Option A

4. Quick Check:

   City = location, Sales = bubble size [OK]

Hint: Numeric Size creates bubble sizes on map [OK]

Common Mistakes:

• Expecting a heatmap instead of bubbles
• Thinking Size cannot be numeric
• Confusing map with table visual

4. You created a map visual but it shows all data points clustered in one spot instead of their real locations. What is the most likely cause?

medium

A. The Location field contains non-geographic text values

B. The Size field is empty

C. The map visual does not support multiple data points

D. The data contains duplicate numeric values

Solution

1. Step 1: Analyze symptom of clustered points

   If all points appear in one spot, Power BI likely cannot recognize the Location field as geographic data.

2. Step 2: Identify cause from options

   Only The Location field contains non-geographic text values correctly identifies the cause, as non-geographic text values prevent proper mapping, causing clustering.

3. Final Answer:

   The Location field contains non-geographic text values -> Option A

4. Quick Check:

   Non-geographic Location = clustered points [OK]

Hint: Check Location field type if points cluster [OK]

Common Mistakes:

• Blaming Size field for location issues
• Assuming map can't show multiple points
• Ignoring data type of Location field

5. You want to create a map visualization showing sales by country with bubble size representing sales and bubble color representing profit margin. Which setup is best in Power BI?

hard

A. Assign Sales to Location, Country to Size, and Profit Margin to Color

B. Assign Profit Margin to Location, Sales to Color, and Country to Size

C. Assign Country to Location, Sales to Size, and Profit Margin to Color

D. Assign Country to Size, Sales to Color, and Profit Margin to Location

Solution

1. Step 1: Identify correct field roles for map

   Country is geographic and belongs in Location; Sales is numeric for bubble Size; Profit Margin is numeric for bubble Color.

2. Step 2: Match options with correct assignments

   Only Assign Country to Location, Sales to Size, and Profit Margin to Color assigns fields correctly: Country to Location, Sales to Size, Profit Margin to Color.

3. Final Answer:

   Assign Country to Location, Sales to Size, and Profit Margin to Color -> Option C

4. Quick Check:

   Location = geography, Size = numeric, Color = numeric [OK]

Hint: Location = geography; Size and Color = numeric fields [OK]

Common Mistakes:

• Putting numeric fields in Location
• Mixing Size and Color roles
• Assigning geography to Size or Color