Dual-axis maps in Tableau - Step-by-Step Guide

Introduction

Dual-axis maps let you combine two map layers in one view. This helps you compare different data points on the same map, like showing sales locations and customer density together.

When you want to show store locations and sales territories on the same map.

When you need to compare two different geographic data sets, like population and income levels.

When you want to overlay points and filled areas to see relationships clearly.

When you want to highlight routes on a map while showing regional boundaries.

When you want to combine a heat map with individual data points for better insight.

Steps

Step 1: Drag the first geographic field (e.g., State) to the Rows shelf

- Tableau worksheet

A map showing the first geographic layer appears

💡 Use a geographic dimension like State or City for the first layer

Step 2: Drag the second geographic field (e.g., City) to the Rows shelf next to the first field

- Tableau worksheet

Two separate maps appear side by side

💡 Make sure the second field is also geographic to create a map

Step 3: Right-click the second geographic field on the Rows shelf and select 'Dual Axis'

- Rows shelf in Tableau worksheet

The two maps overlay on the same axis, creating a combined map

💡 Dual axis merges the two maps into one view

Step 4: Click the drop-down arrow on the second Marks card and choose the desired mark type (e.g., Circle, Shape)

- Marks card for the second geographic field

The second map layer changes to the selected mark type

💡 Use different mark types to distinguish layers visually

Step 5: Synchronize the axes by right-clicking one axis and selecting 'Synchronize Axis'

- Axis on the Rows shelf

Both map layers align perfectly on the same scale

💡 Synchronizing axes ensures accurate overlay

Step 6: Adjust colors and sizes on each Marks card to differentiate layers

- Marks cards for each geographic field

The map layers become visually distinct and clear

💡 Use contrasting colors for better clarity

Before vs After

Before

Two separate maps show State boundaries and City points side by side

After

One combined map shows State boundaries with City points overlaid clearly

Settings Reference

Dual Axis

📍 Right-click on second geographic field on Rows or Columns shelf

Combine two map layers on the same axis for overlay

Default: Single axis

Synchronize Axis

📍 Right-click on axis in the view

Align scales of both map layers for accurate comparison

Default: Unsynchronized

Mark Type

📍 Marks card for each geographic field

Change how data points appear on each map layer

Default: Automatic based on data

Common Mistakes

Not synchronizing axes after creating dual-axis map

The two map layers do not align properly, causing confusion

Always right-click an axis and select 'Synchronize Axis' to align layers

Using non-geographic fields for dual-axis maps

Tableau cannot create map layers without geographic data

Ensure both fields used for dual-axis maps are geographic dimensions

Using the same mark type and color for both layers

Layers blend together and are hard to distinguish

Use different mark types or colors on each Marks card for clarity

Summary

Dual-axis maps let you overlay two geographic layers in one view for better comparison.

You must synchronize axes to align map layers correctly.

Use different mark types and colors to make each layer clear and distinct.

Practice

1. What is the main purpose of using dual-axis maps in Tableau?

easy

A. To layer two map types for better comparison or detail

B. To create a 3D map visualization

C. To filter data based on geographic regions

D. To export maps as images

Solution

1. Step 1: Understand dual-axis maps concept

   Dual-axis maps combine two map layers in one view to show more information.

2. Step 2: Identify the main use

   This layering helps compare or add details like points over filled areas.

3. Final Answer:

   To layer two map types for better comparison or detail -> Option A

4. Quick Check:

   Dual-axis maps = layering two map layers [OK]

Hint: Dual-axis maps layer two map types in one view [OK]

Common Mistakes:

• Thinking dual-axis maps create 3D maps
• Confusing dual-axis maps with filtering
• Assuming dual-axis maps export images

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

easy

A. Create two separate worksheets and combine them in a dashboard

B. Drag one geographic field to Columns and filter by region

C. Use the 'Show Me' panel and select 'Pie Chart'

D. Drag two geographic fields to Rows and then right-click one and select 'Dual Axis'

Solution

1. Step 1: Identify how to create dual-axis maps

   In Tableau, you drag two geographic fields to Rows or Columns, then right-click one and choose 'Dual Axis'.

2. Step 2: Eliminate incorrect options

   Filtering or using 'Show Me' pie chart does not create dual-axis maps; separate worksheets are not dual-axis maps.

3. Final Answer:

   Drag two geographic fields to Rows and then right-click one and select 'Dual Axis' -> Option D

4. Quick Check:

   Dual axis = right-click axis > Dual Axis [OK]

Hint: Right-click axis and choose 'Dual Axis' to combine maps [OK]

Common Mistakes:

• Trying to create dual-axis maps via filtering
• Using 'Show Me' for map layering
• Combining worksheets instead of dual-axis

3. Given two map layers: one showing filled states and another showing city points, what happens if you do NOT synchronize the axes in a dual-axis map?

medium

A. Tableau will automatically merge the layers perfectly

B. The two layers may not align correctly on the map

C. The map will show only one layer

D. The map will display a blank view

Solution

1. Step 1: Understand axis synchronization

   Synchronizing axes ensures both map layers use the same scale and position.

2. Step 2: Consequence of not synchronizing

   Without synchronization, layers may shift and not align properly, causing visual mismatch.

3. Final Answer:

   The two layers may not align correctly on the map -> Option B

4. Quick Check:

   Unsynchronized axes = misaligned layers [OK]

Hint: Always synchronize axes to align map layers correctly [OK]

Common Mistakes:

• Assuming Tableau auto-aligns layers without sync
• Thinking map shows only one layer if unsynced
• Believing unsynced axes cause blank maps

4. You created a dual-axis map but the points layer is not visible on top of the filled map layer. What is the most likely cause?

medium

A. The points layer is hidden behind the filled map layer

B. The marks card for the points layer is set to 'Circle' with zero size

C. The layers are not synchronized

D. The data source is disconnected

Solution

1. Step 1: Check layer order in dual-axis maps

   In dual-axis maps, one layer can hide another if it is on top and opaque.

2. Step 2: Identify why points are invisible

   If points are hidden behind the filled map layer, they won't be visible even if present.

3. Final Answer:

   The points layer is hidden behind the filled map layer -> Option A

4. Quick Check:

   Layer order affects visibility in dual-axis maps [OK]

Hint: Check layer order if points are invisible [OK]

Common Mistakes:

• Assuming unsynchronized axes hide points
• Thinking zero size circle is default
• Blaming data source without checking layers

5. You want to create a dual-axis map showing sales by state as filled areas and customer locations as points. Which steps ensure the map layers align and display correctly?

hard

A. Drag State to Rows, Customer Latitude and Longitude to Rows and Columns, create dual axis, then do NOT synchronize axes

B. Drag State to Detail on one Marks card, Customer Latitude and Longitude to Rows and Columns, create dual axis, then synchronize axes

C. Drag State to Color, Customer Latitude and Longitude to Rows and Columns, create dual axis, then synchronize axes

D. Drag Customer Latitude and Longitude to Rows and Columns, create dual axis, then filter by State

Solution

1. Step 1: Assign State to Color for filled areas

   Using State on Color fills the map areas by state, showing sales distribution.

2. Step 2: Use Customer Latitude and Longitude on Rows and Columns

   These geographic fields plot customer points on the map.

3. Step 3: Create dual axis and synchronize axes

   Dual axis layers the filled states and points; synchronization aligns them correctly.

4. Final Answer:

   Drag State to Color, Customer Latitude and Longitude to Rows and Columns, create dual axis, then synchronize axes -> Option C

5. Quick Check:

   State on Color + Lat/Long + dual axis + sync = correct map [OK]

Hint: Use State on Color and synchronize axes for correct layering [OK]

Common Mistakes:

• Putting State on Detail instead of Color
• Not synchronizing axes after dual axis
• Dragging State to Rows instead of Color