Filled maps (choropleth) in Tableau - Deep Dive

Overview - Filled maps (choropleth)

What is it?

Filled maps, also called choropleth maps, are visualizations that color regions on a map based on data values. Each area, like a state or country, is filled with a color that shows the size or category of a measure. This helps you see patterns and differences across locations quickly. Tableau makes it easy to create these maps by linking your data to geographic areas.

Why it matters

Filled maps help businesses and analysts understand how data changes across different places, like sales by state or population by country. Without them, it would be hard to spot regional trends or problems just by looking at numbers. They turn complex location data into clear, colorful pictures that anyone can understand at a glance.

Where it fits

Before learning filled maps, you should know basic Tableau skills like connecting data and creating simple charts. After this, you can explore advanced map types, combining maps with other visuals, or using map layers and custom geocoding for deeper insights.

Mental Model

Core Idea

A filled map colors each geographic area to show how much or how little a value exists there, making location-based patterns easy to see.

Think of it like...

Imagine coloring a country on a paper map with different shades depending on how many friends live there; darker colors mean more friends, lighter colors mean fewer.

┌───────────────┐
│  Filled Map   │
├───────────────┤
│ Region A ████ │
│ Region B ██   │
│ Region C █████│
│ Region D █    │
└───────────────┘
Colors show data intensity per region.

Build-Up - 7 Steps

1

Foundation

Understanding Geographic Data Basics

Concept: Learn what geographic data is and how Tableau recognizes locations.

Geographic data includes things like countries, states, cities, or postal codes. Tableau has built-in geographic roles that automatically understand these names and place them on maps. For example, if your data has a column named 'State', Tableau can map it to US states.

Result

You can connect your data to a map view in Tableau by dragging geographic fields onto the canvas.

Knowing how Tableau reads geographic data is key to making maps work correctly and avoiding errors like misplacing regions.

2

Foundation

Creating Basic Filled Maps in Tableau

Concept: How to build a simple filled map by assigning colors to regions based on data.

Drag a geographic field like 'State' to the Detail shelf to create map shapes. Then drag a measure like 'Sales' to Color. Tableau fills each state with a color shade representing sales volume. Adjust color legends to improve clarity.

Result

You get a map where each state is colored from light to dark based on sales numbers.

This step shows how data values translate directly into colors on a map, making patterns visible.

3

Intermediate

Choosing Effective Color Schemes

🤔Before reading on: do you think using bright red and green is always best for filled maps? Commit to your answer.

Concept: Learn how color choices affect map readability and meaning.

Colors should be intuitive and accessible. Sequential palettes work well for numeric data, showing low to high values. Diverging palettes help highlight differences around a midpoint. Avoid red-green combos to support colorblind users. Tableau offers built-in palettes and lets you customize colors.

Result

Maps become easier to understand and interpret by more people.

Choosing the right colors prevents confusion and ensures your message is clear to everyone.

4

Intermediate

Handling Data Granularity and Map Detail

🤔Before reading on: do you think filled maps always show detailed city-level data? Commit to your answer.

Concept: Understand how the level of geographic detail affects map usefulness and performance.

Filled maps work best at certain geographic levels like states or countries. Too detailed (like neighborhoods) can clutter the map and slow Tableau. Too broad (like continents) may hide important differences. Choose the right geographic field for your story.

Result

Your map balances detail and clarity, showing meaningful patterns without overload.

Matching data granularity to map scale is crucial for effective visualization.

5

Intermediate

Using Filters and Tooltips to Enhance Maps

Concept: Add interactivity to filled maps to explore data deeper.

Apply filters to focus on specific regions or time periods. Customize tooltips to show extra info when hovering over areas, like exact sales or population. This makes maps interactive and informative without cluttering the view.

Result

Users can explore data dynamically, gaining insights beyond colors alone.

Interactivity turns static maps into powerful exploration tools.

6

Advanced

Custom Geocoding and Map Layers

🤔Before reading on: do you think Tableau can only map standard geographic areas? Commit to your answer.

Concept: Learn how to add custom geographic data and layers for specialized maps.

Sometimes your data has locations Tableau doesn't recognize, like sales territories or custom zones. You can import custom geocoding files (like shapefiles or CSVs with coordinates) to map these areas. Also, you can overlay multiple layers, like points on top of filled regions, for richer maps.

Result

You create tailored maps that fit unique business needs beyond default geography.

Custom geocoding expands Tableau's mapping power to any location-based scenario.

7

Expert

Optimizing Performance and Accuracy in Filled Maps

🤔Before reading on: do you think more map detail always improves insight? Commit to your answer.

Concept: Understand how to balance map detail, data size, and Tableau performance.

Highly detailed filled maps with many regions or complex shapes can slow Tableau and confuse users. Use data aggregation, simplify shapes, or limit map layers to keep performance smooth. Also, check for geographic mismatches or missing data that can cause incorrect coloring. Use Tableau's performance recorder to identify slowdowns.

Result

Maps load quickly, remain accurate, and communicate clearly even with large datasets.

Knowing how to optimize maps prevents slow dashboards and misleading visuals in real projects.

Under the Hood

Tableau links your data's geographic fields to built-in geographic roles or custom geocoding. It then draws polygons for each region on a map canvas. The measure values you assign to color control the fill shade of each polygon. Tableau uses color scales to translate numbers into colors smoothly. When you interact with the map, Tableau queries the data and redraws the map dynamically.

Why designed this way?

Filled maps were designed to combine spatial location with quantitative data visually, making complex geographic patterns easy to understand. Tableau built-in geographic roles and automatic mapping simplify map creation for users without GIS expertise. The color fill approach leverages human ability to quickly interpret color intensity, making data comparisons intuitive.

┌───────────────┐       ┌───────────────┐
│ Data with    │       │ Tableau       │
│ Geographic   │──────▶│ Geographic    │
│ Fields       │       │ Roles & Map   │
└───────────────┘       └───────────────┘
         │                      │
         ▼                      ▼
┌───────────────────────────────┐
│ Map Canvas with Polygons       │
│ Colored by Measure Values      │
└───────────────────────────────┘

Myth Busters - 4 Common Misconceptions

Quick: do you think filled maps always show exact data values for each region? Commit to yes or no.

Common Belief: Filled maps show precise data values for every area exactly as in the data.

Reality: Filled maps show color ranges representing data, not exact numbers. Colors approximate values and depend on the color scale chosen.

Why it matters: Assuming exact values can lead to wrong conclusions; always check tooltips or labels for precise numbers.

Quick: do you think any geographic name in your data will map correctly in Tableau without errors? Commit to yes or no.

Common Belief: Tableau automatically maps all geographic names correctly without any preparation.

Reality: Tableau requires standard geographic names or custom geocoding. Misspellings or non-standard names cause missing or misplaced regions.

Why it matters: Incorrect mapping leads to incomplete or misleading maps, hiding important data.

Quick: do you think using many colors always makes a filled map better? Commit to yes or no.

Common Belief: More colors on a filled map always improve understanding by showing more detail.

Reality: Too many colors confuse viewers and make patterns harder to see. Simple, well-chosen palettes work best.

Why it matters: Overcomplicated colors reduce map clarity and user comprehension.

Quick: do you think filled maps are always the best choice for geographic data? Commit to yes or no.

Common Belief: Filled maps are the best way to show any geographic data.

Reality: Filled maps are great for area-based data but not for point data or routes. Other map types like symbol maps or flow maps may be better.

Why it matters: Choosing the wrong map type can hide insights or mislead users.

Expert Zone

1

Tableau's map rendering uses vector shapes that can be simplified for performance without losing visual quality, a subtle balance experts manage.

2

Color scaling can be customized with calculated fields to create non-linear or threshold-based fills, enabling advanced storytelling.

3

Combining filled maps with parameter controls allows dynamic switching of measures or geographic levels, a powerful interactive technique.

When NOT to use

Avoid filled maps when your data is about specific points (like store locations) or movement (like delivery routes). Use symbol maps or flow maps instead. Also, if your geographic data is too granular or incomplete, filled maps may mislead or perform poorly.

Production Patterns

Professionals use filled maps in dashboards to highlight regional sales performance, demographic distributions, or risk areas. They combine them with filters and tooltips for interactivity and often layer multiple map types for richer insights. Custom geocoding is common in industries with unique territories.

Connections

Heatmaps

Similar pattern of using color intensity to show data density or value.

Understanding filled maps helps grasp heatmaps since both use color gradients to reveal patterns, just on geographic vs. grid layouts.

Cartography

Filled maps are a digital form of choropleth maps, a classic cartography technique.

Knowing cartography principles like color theory and map projection improves filled map design and accuracy.

Human Visual Perception

Filled maps rely on how humans perceive color differences to communicate data.

Understanding color perception and accessibility guides better color palette choices for clearer, inclusive maps.

Common Pitfalls

#1 Using non-standard or misspelled geographic names causing missing map regions.

Wrong approach:

Data with 'Californa' instead of 'California' as state name, then dragging State to map.

Correct approach:

Correct spelling 'California' in data before mapping.

Root cause:

Tableau matches geographic names exactly; typos break this link.

#2 Applying a categorical color palette to continuous numeric data on a filled map.

Wrong approach:

Dragging Sales to Color and selecting a palette with distinct colors for categories.

Correct approach:

Use a sequential color palette for Sales to show gradual differences.

Root cause:

Mismatch between data type and color palette confuses interpretation.

#3 Overloading filled maps with too many geographic levels or layers causing clutter and slow performance.

Wrong approach:

Adding State, City, and Zip Code all to Detail and Color shelves simultaneously.

Correct approach:

Choose one geographic level appropriate for the analysis and keep layers minimal.

Root cause:

Too much detail overwhelms the map and Tableau's rendering engine.

Key Takeaways

Filled maps color geographic areas to show data differences visually, making location patterns easy to spot.

Choosing the right geographic level and color scheme is essential for clear, accurate maps.

Tableau simplifies map creation but requires clean geographic data and thoughtful design choices.

Interactivity like filters and tooltips enhances filled maps by letting users explore details.

Advanced users customize geocoding and optimize map performance for complex, real-world scenarios.

Practice

1. What is the main purpose of a filled map (choropleth) in Tableau?

easy

A. To color geographic areas based on data values

B. To display detailed street-level maps

C. To show individual data points as dots

D. To create 3D maps with elevation

Solution

1. Step 1: Understand filled map concept

   A filled map colors entire geographic areas (like states or countries) based on data values.

2. Step 2: Compare with other map types

   Unlike dot maps or 3D maps, filled maps focus on coloring regions, not points or elevation.

3. Final Answer:

   To color geographic areas based on data values -> Option A

4. Quick Check:

   Filled maps = color areas by data [OK]

Hint: Remember: filled maps color regions, not points or lines [OK]

Common Mistakes:

• Confusing filled maps with point maps
• Thinking filled maps show street details
• Assuming filled maps create 3D effects

2. Which of the following is the correct way to create a filled map in Tableau?

easy

A. Drag a geographic field to Filters and a measure to Size

B. Drag a measure to Rows and a geographic field to Tooltip

C. Drag a geographic field to Rows and a measure to Color on the Marks card

D. Drag a measure to Columns and a geographic field to Detail

Solution

1. Step 1: Identify how to build filled maps

   In Tableau, dragging a geographic field (like State) to Rows or Columns creates the map base.

2. Step 2: Add color by measure

   Placing a measure on Color in the Marks card colors the geographic areas based on data values.

3. Final Answer:

   Drag a geographic field to Rows and a measure to Color on the Marks card -> Option C

4. Quick Check:

   Geo field + Color measure = filled map [OK]

Hint: Put geography on Rows/Columns and measure on Color [OK]

Common Mistakes:

• Putting geographic fields in Tooltip instead of Rows/Columns
• Using Size instead of Color for data values
• Not dragging any measure to Color

3. Given a filled map showing sales by state, what will happen if you drag the Sales measure to the Color shelf and set the aggregation to SUM?

medium

A. Each state will be colored based on total sales in that state

B. The map will show individual sales transactions as dots

C. The map will display sales as labels on each state

D. The map will become blank because SUM is invalid here

Solution

1. Step 1: Understand SUM aggregation on measure

   SUM aggregates all sales values per state, giving total sales per state.

2. Step 2: Effect on filled map coloring

   Coloring by SUM(Sales) colors each state area based on its total sales amount.

3. Final Answer:

   Each state will be colored based on total sales in that state -> Option A

4. Quick Check:

   SUM(Sales) colors states by total sales [OK]

Hint: SUM on measure colors areas by total values [OK]

Common Mistakes:

• Thinking dots appear instead of colored areas
• Expecting labels instead of colors
• Assuming SUM aggregation causes errors

4. You created a filled map but the colors do not change when you drag your measure to Color. What is the most likely reason?

medium

A. The measure is not numeric

B. The map type is set to Symbol Map instead of Filled Map

C. You forgot to add the geographic field to Detail or Rows/Columns

D. The geographic field is not recognized correctly

Solution

1. Step 1: Check map type setting

   If the map type is Symbol Map, colors apply to points, not areas, so filled colors won't appear.

2. Step 2: Confirm filled map selection

   Switching to Filled Map enables coloring of geographic areas by measure values.

3. Final Answer:

   The map type is set to Symbol Map instead of Filled Map -> Option B

4. Quick Check:

   Symbol Map ≠ filled colors; choose Filled Map [OK]

Hint: Check map type: must be Filled Map for area colors [OK]

Common Mistakes:

• Assuming measure type causes no color change
• Not verifying map type in Marks card
• Ignoring geographic field placement

5. You want to create a filled map showing population density by US state, but your data only has total population and land area separately. How should you prepare your data in Tableau to color states by population density?

hard

A. Use total population as Color and filter states by land area

B. Drag total population to Color and land area to Size

C. Create a parameter for land area and use it to filter states

D. Create a calculated field dividing total population by land area, then drag it to Color

Solution

1. Step 1: Calculate population density

   Create a calculated field: Population Density = Total Population / Land Area.

2. Step 2: Use calculated field for coloring

   Drag this new field to Color on the Marks card to color states by density.

3. Final Answer:

   Create a calculated field dividing total population by land area, then drag it to Color -> Option D

4. Quick Check:

   Calculated field = density, use on Color [OK]

Hint: Calculate density first, then color map by it [OK]

Common Mistakes:

• Using raw population without area for color
• Using Size for land area instead of calculation
• Filtering states instead of calculating density