Filled maps (choropleth) in Tableau - Practice Problems & Coding Challenges

Challenge - 5 Problems

❓ visualization

intermediate

Identify the correct step to create a filled map in Tableau

You want to create a filled map (choropleth) showing sales by state in Tableau. Which step is essential to convert the map into a filled map?

A Drag the 'Sales' measure to Color on the Marks card and change the mark type to 'Filled Map'.

B Drag the 'State' dimension to the Detail on the Marks card and change the mark type to 'Map'.

C Drag the 'State' dimension to the Rows shelf and 'Sales' to the Columns shelf.

D Drag the 'Sales' measure to Tooltip and set the mark type to 'Circle'.

💡 Hint

Think about how color fills the areas on the map to represent data.

To create a filled map, you must assign a measure to Color and set the mark type to 'Filled Map'. This colors each area based on the measure.

❓ dax_lod_result

intermediate

Calculate total sales per state ignoring filters

In Tableau, you want to calculate total sales per state ignoring any filters applied on the dashboard. Which Tableau calculation will achieve this?

A { FIXED [State] : SUM([Sales]) }

B SUM([Sales])

C { INCLUDE [State] : SUM([Sales]) }

D { EXCLUDE [State] : SUM([Sales]) }

💡 Hint

Think about how to fix the calculation at the state level regardless of filters.

The FIXED LOD expression calculates the sum of sales for each state ignoring filters except context filters.

🧠 Conceptual

advanced

Why use filled maps instead of symbol maps?

Which reason best explains why you would choose a filled map (choropleth) over a symbol map in Tableau?

A Filled maps use symbols to represent data points, which is better for showing exact locations.

B Filled maps are faster to create because they require fewer data fields.

C Filled maps show data distribution by coloring entire geographic areas, making it easier to compare regions visually.

D Filled maps always display data labels automatically, unlike symbol maps.

💡 Hint

Consider how color fills help in understanding data across regions.

Filled maps color entire geographic areas to show data distribution, which helps in comparing regions easily. Symbol maps use points and are better for precise locations.

🔧 Formula Fix

advanced

Troubleshoot missing filled map colors

You created a filled map in Tableau, but some states show no color fill even though data exists. What is the most likely cause?

A The filter on the dashboard excludes those states, so they do not appear.

B The geographic role for the state field is not set correctly, so Tableau cannot map the data.

C The measure used for color has null values for those states, so Tableau leaves them blank.

D The map background is turned off, hiding the filled areas.

💡 Hint

Check how Tableau recognizes your geographic data.

If the geographic role is incorrect, Tableau cannot assign the data to map areas, resulting in missing color fills.

🎯 Scenario

expert

Optimize performance for a filled map with many regions

You have a filled map showing sales by thousands of small geographic regions. The map loads slowly and is hard to interpret. What is the best approach to improve performance and clarity?

A Remove the color encoding and use labels instead to show sales values.

B Increase the size of the marks to make each region more visible.

C Add more color categories to show finer differences in sales values.

D Aggregate the data to a higher geographic level (e.g., state instead of zip code) and use filters to limit visible regions.

💡 Hint

Think about simplifying the data and reducing detail for better speed and readability.

Aggregating data to a higher geographic level reduces the number of areas Tableau must render, improving performance and making the map easier to understand.