Map visualizations in Power BI - Practice Problems & Coding Challenges

Challenge - 5 Problems

❓ visualization

intermediate

Choosing the correct map type for sales data

You have sales data by country and want to show total sales geographically. Which map visualization type in Power BI best shows sales distribution by country with clear color intensity differences?

A Shape map showing sales as pie charts on each country

B Bubble map with bubbles sized by sales volume on a blank map

C Table visual listing countries and sales values

D Choropleth map (filled map) showing countries colored by sales volume

💡 Hint

Think about which map type uses color fill to represent values across regions.

A choropleth map colors entire countries based on sales volume, making it easy to compare regions by color intensity. Bubble maps show points but can be less clear for whole country comparisons.

❓ dax_lod_result

intermediate

Calculate total sales by city ignoring filters

Given a sales table with columns City and SalesAmount, which DAX measure correctly calculates total sales for each city ignoring any slicers or filters on City?

Power BI

Total Sales All Cities = CALCULATE(SUM(Sales[SalesAmount]), ALL(Sales[City]))

A Total Sales All Cities = CALCULATE(SUM(Sales[SalesAmount]), FILTER(Sales, Sales[City] <> ""))

B Total Sales All Cities = SUM(Sales[SalesAmount])

C Total Sales All Cities = CALCULATE(SUM(Sales[SalesAmount]), ALL(Sales[City]))

D Total Sales All Cities = CALCULATE(SUM(Sales[SalesAmount]), REMOVEFILTERS(Sales[City]))

💡 Hint

Use a function that removes filters on the City column inside CALCULATE.

ALL(Sales[City]) removes any filters on City, so the measure sums sales for all cities regardless of slicers.

❓ data_modeling

advanced

Modeling geographic hierarchy for map drill-down

You want to create a map visualization that allows users to drill down from Country to State to City. What is the best way to model this geographic hierarchy in Power BI?

A Create separate tables for Country, State, City with no relationships and use them independently

B Create a single table with columns Country, State, City and define a hierarchy in the Fields pane

C Use only the City column with full names including State and Country concatenated

D Create a table with only Country and City columns and ignore State

💡 Hint

Think about how Power BI hierarchies work in the Fields pane.

A single table with all geographic levels lets you define a hierarchy that users can drill down in map visuals smoothly.

🎯 Scenario

advanced

Improving map performance with many data points

Your map visualization slows down when showing thousands of city points. Which approach best improves performance without losing key insights?

A Aggregate data to show sales by State instead of City to reduce points

B Use a bubble map with larger bubbles for each city

C Add more detailed city-level data to increase granularity

D Remove all filters and show all data points at once

💡 Hint

Think about reducing the number of points shown to improve speed.

Aggregating data to a higher geographic level reduces points and improves map rendering speed while keeping meaningful insights.

🔧 Formula Fix

expert

Identify the error in this DAX measure for map tooltip

Given this DAX measure intended to show average sales per city in a map tooltip, what error will it cause?

Avg Sales Tooltip = AVERAGE(Sales[SalesAmount], Sales[City])

Power BI

Avg Sales Tooltip = AVERAGE(Sales[SalesAmount], Sales[City])

A SyntaxError: AVERAGE function only takes one argument

B Returns average sales correctly grouped by city

C TypeError: Cannot average text values in City column

D Returns total sales instead of average

💡 Hint

Check the number of arguments AVERAGE accepts.

AVERAGE only accepts one column argument. Passing two arguments causes a syntax error.