Parameter controls in Tableau - Step-by-Step Guide

Introduction

Parameter controls let you add interactive inputs to your Tableau dashboard. They help users change values like numbers or dates to see different views without changing the data source.

When you want users to select a specific year to filter sales data on a dashboard.

When you want to let users choose a target sales goal to compare actual sales against.

When you want to switch between different calculation methods like sum or average in a chart.

When you want to allow users to input a threshold value to highlight data points above it.

When you want to create a dynamic title that changes based on user input.

Steps

Step 1: Create a new parameter

- Data pane, right-click and select 'Create Parameter...'

The Create Parameter dialog opens where you can define the parameter's name, data type, and allowable values

💡 Choose a clear name that describes what the parameter controls

Step 2: Set parameter properties

- Create Parameter dialog

You define the data type (e.g., integer, string, date), allowable range or list of values, and current value

💡 Use a list of values for fixed options or a range for numeric inputs

Step 3: Click 'OK' to create the parameter

- Create Parameter dialog

The parameter appears in the Data pane under Parameters

💡 Parameters do not filter data by themselves; you must use them in calculations or filters

Step 4: Show the parameter control

- Right-click the parameter in the Data pane and select 'Show Parameter Control'

A control appears on the worksheet or dashboard allowing users to change the parameter value

💡 Place the control in a visible area on your dashboard for easy access

Step 5: Use the parameter in a calculated field

- Analysis tab > Create Calculated Field

You create a formula that uses the parameter value to change the data or calculation dynamically

💡 Example: IF [Sales] > [Target Parameter] THEN 'Above Target' ELSE 'Below Target' END

Step 6: Add the calculated field to your view or filter

- Drag the calculated field to Rows, Columns, Color, or Filters shelf

The view updates based on the parameter value users select

💡 Test different parameter values to see how the view changes

Before vs After

Before

Dashboard shows static sales data for all years with no user input options

After

Dashboard includes a parameter control allowing users to select a year, updating sales data dynamically for that year

Settings Reference

Data type

📍 Create Parameter dialog

Defines the kind of values the parameter can hold

Default: Integer

Allowable values

📍 Create Parameter dialog

Controls which values users can select or input

Default: All

Current value

📍 Create Parameter dialog

Sets the initial value shown when the parameter control appears

Default: First value or minimum in range

Display format

📍 Parameter properties after creation

Controls how the parameter value is shown to users

Default: Automatic

Common Mistakes

Creating a parameter but not using it in any calculation or filter

Parameters alone do not filter or change data; they must be referenced in calculations or filters to have effect

Always create a calculated field or filter that uses the parameter value to control the view

Setting parameter allowable values too broadly, like 'All' for a numeric range without limits

Users can enter unexpected values that break calculations or cause confusing results

Use a list or range with clear minimum and maximum values to guide user input

Placing the parameter control in a hidden or hard-to-find area on the dashboard

Users may not notice the control and miss the interactive feature

Place parameter controls in visible, logical spots with clear labels

Summary

Parameter controls let users interactively change values to update views dynamically.

You must create a parameter, show its control, and use it in calculations or filters.

Set clear data types and allowable values to guide user input and avoid errors.

Practice

1. What is the main purpose of a parameter control in Tableau dashboards?

easy

A. To export data to Excel

B. To permanently change the data source

C. To create new data tables

D. To let users select values that dynamically change the view

Solution

1. Step 1: Understand parameter control function

   Parameter controls allow users to pick values that affect dashboard visuals dynamically.

2. Step 2: Compare options to this function

   Only To let users select values that dynamically change the view describes this dynamic user interaction; others describe unrelated actions.

3. Final Answer:

   To let users select values that dynamically change the view -> Option D

4. Quick Check:

   Parameter control = dynamic user input [OK]

Hint: Parameters let users pick values to change views [OK]

Common Mistakes:

• Thinking parameters change data source permanently
• Confusing parameters with filters that remove data
• Assuming parameters create new tables

2. Which of the following is the correct way to create a parameter control in Tableau?

easy

A. Drag a field to Rows shelf

B. Right-click in Data pane > Create > Parameter

C. Use Data > Export > Parameter

D. Right-click on a worksheet > Add Filter

Solution

1. Step 1: Recall how to create parameters

   In Tableau, parameters are created by right-clicking in the Data pane and selecting Create > Parameter.

2. Step 2: Eliminate incorrect options

   Dragging fields or exporting data does not create parameters; adding filters is different from parameters.

3. Final Answer:

   Right-click in Data pane > Create > Parameter -> Option B

4. Quick Check:

   Create parameter = Data pane right-click [OK]

Hint: Create parameters via Data pane right-click [OK]

Common Mistakes:

• Trying to create parameters from worksheet menus
• Confusing filters with parameters
• Looking for parameters in export options

3. Given a parameter Selected Year with values 2019, 2020, 2021, and a calculated field Sales for Year defined as IF [Year] = [Selected Year] THEN [Sales] ELSE 0 END, what happens when the user sets the parameter to 2020?

medium

A. All sales values are shown regardless of year

B. Sales values for 2019 are shown

C. Sales values for 2020 are shown; others are zero

D. The dashboard crashes due to syntax error

Solution

1. Step 1: Understand the calculated field logic

   The field returns sales only if the data's Year matches the parameter value; otherwise zero.

2. Step 2: Apply parameter value 2020

   When parameter is 2020, only sales for 2020 show; others become zero.

3. Final Answer:

   Sales values for 2020 are shown; others are zero -> Option C

4. Quick Check:

   Parameter filters sales by year = 2020 [OK]

Hint: Parameter filters data by matching values [OK]

Common Mistakes:

• Assuming all sales show regardless of parameter
• Confusing parameter with filter that removes rows
• Thinking syntax error occurs

4. You created a parameter control but it does not appear on the dashboard. What is the most likely reason?

medium

A. You forgot to show the parameter control on the worksheet

B. The parameter has no values

C. The data source is disconnected

D. Parameters cannot be added to dashboards

Solution

1. Step 1: Check parameter visibility

   Parameters must be explicitly shown by right-clicking and selecting 'Show Parameter Control'.

2. Step 2: Evaluate other options

   Parameters always have values when created; data source issues or dashboard restrictions do not hide parameters.

3. Final Answer:

   You forgot to show the parameter control on the worksheet -> Option A

4. Quick Check:

   Show parameter control to display it [OK]

Hint: Right-click parameter > Show Parameter Control to display [OK]

Common Mistakes:

• Assuming parameters show automatically
• Thinking parameters depend on data connection
• Believing parameters cannot be on dashboards

5. You want users to select a sales target from a list (10000, 20000, 30000) and highlight products exceeding that target. Which steps correctly implement this using parameter controls?

hard

A. Create a parameter with target values, create a calculated field comparing sales to parameter, then add the field to color on the view

B. Create a filter with target values, drag sales to rows, and add parameter to tooltip

C. Create a parameter with target values, export data, then manually highlight products

D. Create a calculated field with fixed sales, ignore parameter, and add to detail

Solution

1. Step 1: Create parameter with target values

   Define a parameter listing sales targets (10000, 20000, 30000) for user selection.

2. Step 2: Create calculated field comparing sales to parameter

   Use a formula like IF [Sales] > [Target Parameter] THEN 'Above Target' ELSE 'Below Target' END.

3. Step 3: Add calculated field to color on the view

   This colors products based on whether they exceed the selected target.

4. Final Answer:

   Create a parameter with target values, create a calculated field comparing sales to parameter, then add the field to color on the view -> Option A

5. Quick Check:

   Parameter + calc field + color = highlight [OK]

Hint: Use parameter + calc field + color to highlight dynamically [OK]

Common Mistakes:

• Using filters instead of parameters for dynamic input
• Exporting data instead of interactive highlighting
• Ignoring parameter in calculated field