Dynamic measure swap in Tableau - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is a dynamic measure swap in Tableau?

A dynamic measure swap lets you switch between different measures in a single view using a control like a parameter, so you can compare or analyze data without creating multiple charts.

beginner

How do you create a dynamic measure swap in Tableau?

You create a parameter listing the measures, then a calculated field that uses the parameter to choose which measure to show. Finally, you use this calculated field in your view.

intermediate

Why use a parameter instead of filters for dynamic measure swap?

Parameters let you swap measures dynamically in one chart without filtering data out, keeping all data available and improving user experience.

intermediate

What is a calculated field example for dynamic measure swap?

Example: IF [Measure Parameter] = 'Sales' THEN SUM([Sales]) ELSEIF [Measure Parameter] = 'Profit' THEN SUM([Profit]) ELSE SUM([Quantity]) END

beginner

What is a common use case for dynamic measure swap?

It helps business users quickly compare different metrics like sales, profit, or quantity in the same chart without switching dashboards.

What Tableau feature is essential for creating a dynamic measure swap?

A Dashboard Action

B Filter

C Data Source

D Parameter

Parameters allow users to select which measure to display dynamically.

Which Tableau element uses the parameter to show the selected measure?

A Tooltip

B Calculated Field

C Color Legend

D Filter Shelf

A calculated field uses the parameter value to decide which measure to display.

What is the main benefit of dynamic measure swap?

A Switching between measures without multiple charts

B Filtering data by date

C Changing data source

D Adding more rows to the table

It lets users switch measures in one chart, saving space and improving analysis.

Which of these is NOT a step in creating a dynamic measure swap?

A Create a filter to remove unwanted data

B Create a calculated field using the parameter

C Create a parameter listing measures

D Use the calculated field in the view

Filters remove data; dynamic measure swap uses parameters and calculated fields instead.

If your parameter has options 'Sales' and 'Profit', what does the calculated field do?

A Changes the color of the chart

B Filters data to only sales or profit rows

C Shows SUM(Sales) or SUM(Profit) based on parameter choice

D Sorts the data alphabetically

The calculated field returns the sum of the selected measure based on the parameter.

Explain how to set up a dynamic measure swap in Tableau step-by-step.

Think about how users choose measures and how Tableau shows them.

Describe why dynamic measure swap improves dashboard usability.

Consider user experience and dashboard space.