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.