Synchronizing axes in Tableau - Practice Problems & Coding Challenges

Challenge - 5 Problems

🧠 Conceptual

intermediate

Why synchronize axes in Tableau?

Imagine you have two measures plotted on dual axes in Tableau. Why is it important to synchronize these axes?

A To ensure both measures use the same scale for accurate visual comparison.

B To make the chart load faster by reducing data points.

C To automatically filter data based on user selection.

D To change the color of the marks on the chart.

💡 Hint

Think about how different scales can affect how you see the data together.

Synchronizing axes aligns the scales of two measures so you can compare their values directly on the same visual scale.

❓ visualization

intermediate

Identify the synchronized axes chart

Below are descriptions of four Tableau dual-axis charts. Which one shows synchronized axes?

A Axes have different colors but same scale ranges.

B Axes are hidden but scales differ significantly.

C One axis ranges from 0 to 100, the other from 0 to 1000, lines appear misaligned.

D Both axes have the same range from 0 to 100, and the lines overlap correctly.

💡 Hint

Look for matching scale ranges on both axes.

Synchronized axes have identical scale ranges, so the data points align properly on the chart.

❓ dax_lod_result

advanced

DAX measure for synchronized axes effect

You want to create a measure in Power BI that mimics synchronized axes behavior by normalizing two measures to the same scale. Which DAX expression correctly normalizes Measure1 and Measure2 between 0 and 1?

A NormalizedMeasure1 = Measure1 - AVERAGE(Measure1)

B NormalizedMeasure1 = (Measure1 - MIN(Measure1)) / (MAX(Measure1) - MIN(Measure1))

C NormalizedMeasure1 = DIVIDE(Measure1, MAX(Measure1))

D NormalizedMeasure1 = Measure1 / SUM(Measure1)

💡 Hint

Normalization rescales values between minimum and maximum.

Option B correctly rescales Measure1 to a 0-1 range by subtracting the minimum and dividing by the range.

🔧 Formula Fix

advanced

Why does the dual axis chart not synchronize?

You created a dual axis chart in Tableau but the axes are not synchronized even after clicking 'Synchronize Axis'. What could be the reason?

A The axes are already synchronized by default.

B The chart has filters applied that exclude some data points.

C The measures have different data types, preventing synchronization.

D The workbook is in read-only mode.

💡 Hint

Check if both measures are numeric and compatible.

Tableau requires both axes to have compatible numeric data types to synchronize scales.

🎯 Scenario

expert

Designing a synchronized dual axis dashboard

You are building a Tableau dashboard showing sales and profit over time using dual axes. Sales values range from 0 to 1,000,000 and profit from 0 to 100,000. How should you synchronize axes to make the comparison meaningful?

A Normalize both sales and profit to a 0-1 scale before plotting and then synchronize axes.

B Plot raw sales and profit values and synchronize axes directly.

C Use separate axes without synchronization to keep original scales.

D Convert profit to thousands and synchronize axes with sales.

💡 Hint

Think about how to compare two measures with very different scales visually.

Normalizing both measures to the same scale before plotting allows synchronization to show relative trends clearly.

Practice

1. What is the main purpose of synchronizing axes in Tableau when using dual-axis charts?

easy

A. To filter data based on axis values

B. To create separate charts for each measure

C. To change the color of the axes

D. To align multiple measures on the same scale for easier comparison

Solution

1. Step 1: Understand dual-axis charts

   Dual-axis charts combine two measures on one view but may have different scales.

2. Step 2: Purpose of synchronizing axes

   Synchronizing axes aligns these scales so the measures can be compared directly.

3. Final Answer:

   To align multiple measures on the same scale for easier comparison -> Option D

4. Quick Check:

   Synchronizing axes = aligned scales [OK]

Hint: Synchronize axes to compare measures on the same scale [OK]

Common Mistakes:

• Thinking it changes colors
• Believing it filters data
• Assuming it creates separate charts

2. Which of the following is the correct way to enable axis synchronization in Tableau for a dual-axis chart?

easy

A. Right-click on one axis and select 'Synchronize Axis'

B. Drag one measure over the other measure in the data pane

C. Use the 'Filter' shelf to synchronize axes

D. Change the mark type to 'Bar'

Solution

1. Step 1: Locate axis options

   In a dual-axis chart, right-clicking an axis shows options related to that axis.

2. Step 2: Enable synchronization

   Selecting 'Synchronize Axis' aligns the scales of both axes.

3. Final Answer:

   Right-click on one axis and select 'Synchronize Axis' -> Option A

4. Quick Check:

   Right-click axis -> Synchronize Axis [OK]

Hint: Right-click axis to find 'Synchronize Axis' option [OK]

Common Mistakes:

• Trying to drag measures to synchronize
• Using filters to sync axes
• Changing mark types instead

3. Given a dual-axis chart with Sales and Profit measures, what happens if you do NOT synchronize the axes?

medium

A. Sales and Profit will be shown on different scales, making direct comparison difficult

B. Both measures will be combined into a single measure

C. The chart will show an error and not render

D. The axes will automatically synchronize anyway

Solution

1. Step 1: Understand dual-axis without synchronization

   Without synchronization, each axis uses its own scale based on its data range.

2. Step 2: Effect on comparison

   This causes Sales and Profit to appear on different scales, making it hard to compare values visually.

3. Final Answer:

   Sales and Profit will be shown on different scales, making direct comparison difficult -> Option A

4. Quick Check:

   Unsynchronized axes = different scales [OK]

Hint: No sync means different scales, hard to compare [OK]

Common Mistakes:

• Thinking measures combine automatically
• Expecting an error to occur
• Assuming axes sync by default

4. You created a dual-axis chart but the 'Synchronize Axis' option is grayed out. What is the most likely cause?

medium

A. The chart type is set to pie chart

B. You forgot to add a filter to the view

C. One or both axes are using discrete (categorical) fields instead of continuous fields

D. The data source is not connected

Solution

1. Step 1: Check field types for axes

   Synchronizing axes requires continuous fields because only continuous axes have numeric scales.

2. Step 2: Identify why option is disabled

   If one or both axes use discrete fields, the option to synchronize is disabled (grayed out).

3. Final Answer:

   One or both axes are using discrete (categorical) fields instead of continuous fields -> Option C

4. Quick Check:

   Discrete fields disable sync option [OK]

Hint: Sync needs continuous fields, not discrete [OK]

Common Mistakes:

• Thinking filters affect sync availability
• Assuming data connection causes this
• Confusing chart types with axis sync

5. You want to create a combined line and bar chart in Tableau showing Sales (bar) and Profit (line) on the same view. How do you ensure the axes are synchronized for accurate comparison?

hard

A. Place Sales and Profit on separate sheets and combine them in a dashboard

B. Create a dual-axis chart, set Sales as bar, Profit as line, then right-click Profit axis and select 'Synchronize Axis'

C. Use a filter to show only Sales or Profit at a time

D. Change both measures to discrete fields before creating the chart

Solution

1. Step 1: Build dual-axis chart with different mark types

   Drag Sales and Profit to Rows, create dual-axis, assign Sales to bar and Profit to line marks.

2. Step 2: Synchronize axes for scale alignment

   Right-click the Profit axis and select 'Synchronize Axis' to align scales for comparison.

3. Final Answer:

   Create a dual-axis chart, set Sales as bar, Profit as line, then right-click Profit axis and select 'Synchronize Axis' -> Option B

4. Quick Check:

   Dual-axis + sync axis = aligned combined chart [OK]

Hint: Dual-axis + sync axis for combined bar and line chart [OK]

Common Mistakes:

• Using separate sheets instead of dual-axis
• Filtering measures instead of syncing axes
• Changing measures to discrete disables sync