Dual axis charts in Tableau - Practice Problems & Coding Challenges

Challenge - 5 Problems

🧠 Conceptual

intermediate

Understanding Dual Axis Charts Purpose

What is the main advantage of using a dual axis chart in Tableau?

A To compare two different measures with different scales on the same chart

B To display multiple dimensions on a single axis

C To filter data dynamically based on user input

D To create a 3D visualization effect

💡 Hint

Think about why you would want two vertical scales on one chart.

Dual axis charts allow you to plot two measures with different units or scales on the same graph, making comparison easier.

❓ dax_lod_result

intermediate

Calculating Combined Measure for Dual Axis

Given two measures: Sales and Profit Margin, which DAX expression correctly calculates the average profit margin for use in a dual axis chart?

A CALCULATE(AVERAGE('SalesData'[Profit Margin]), ALL('SalesData'))

B SUM('SalesData'[Profit Margin]) / COUNT('SalesData'[Sales])

C DIVIDE(SUM('SalesData'[Profit]), SUM('SalesData'[Sales]))

D AVERAGE('SalesData'[Profit Margin])

💡 Hint

Look for the function that directly calculates average without filtering.

AVERAGE('SalesData'[Profit Margin]) directly computes the average profit margin, suitable for plotting alongside sales.

❓ visualization

advanced

Identifying Correct Dual Axis Chart Setup

You want to create a dual axis chart in Tableau showing Monthly Sales as bars and Monthly Profit Margin as a line. Which setup correctly achieves this?

A Drag Sales and Profit Margin to Columns, then select 'Dual Axis' from the Analysis menu

B Place Sales and Profit Margin on Color shelf, then enable Dual Axis from the Marks card

C Drag Sales to Rows, Profit Margin to Rows, right-click second axis and select 'Dual Axis', then change Profit Margin mark type to Line

D Create two separate sheets and combine them in a dashboard

💡 Hint

Remember how dual axis charts are created by layering two measures on the same axis.

Dragging both measures to Rows and then selecting 'Dual Axis' on the second axis allows overlaying them. Changing the mark type for one measure to Line creates the desired combo chart.

🔧 Formula Fix

advanced

Fixing Misaligned Dual Axis Chart

You created a dual axis chart in Tableau but the two axes are not aligned, causing confusion. What is the most likely cause?

A The data source is missing a join between tables

B The two axes have different ranges and 'Synchronize Axis' was not selected

C The marks card is set to 'Automatic' instead of 'Bar' for both measures

D The filters applied are inconsistent between the two measures

💡 Hint

Think about how axis scales affect dual axis charts.

If axes have different scales and are not synchronized, the chart looks misaligned. Synchronizing axes fixes this.

🎯 Scenario

expert

Designing a Responsive Dual Axis Dashboard

You are designing a Tableau dashboard with a dual axis chart showing Revenue and Customer Satisfaction. The dashboard must be accessible and responsive for users on different devices. Which practice is NOT recommended?

A Fix the dashboard width to a large pixel value to maintain chart size

B Add clear axis titles and tooltips explaining each measure

C Use contrasting colors with sufficient contrast ratio for the two measures

D Enable keyboard navigation and screen reader friendly labels

💡 Hint

Consider responsive design principles for dashboards.

Fixing dashboard width to a large pixel value reduces responsiveness and accessibility on smaller devices. Using flexible layouts is better.