Creating parameters in Tableau - Complete Walkthrough

Introduction

Parameters let you add interactive controls to your Tableau dashboards. They help users pick values that change the view or calculations without changing the data source.

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

When you need to switch between different measures like profit or revenue in a chart.

When you want to let users input a target number to compare against actual results.

When you want to create a dynamic reference line that users can adjust.

When you want to toggle between different calculation methods in a report.

Steps

Step 1: Click

- Data pane dropdown menu

A menu opens with options related to data fields and parameters

Step 2: Select

- Create Parameter

The Create Parameter dialog box appears

Step 3: Type

- Name field in Create Parameter dialog

You enter a clear name for the parameter, like 'Select Year'

Step 4: Choose

- Data type dropdown in Create Parameter dialog

You select the type of values the parameter will hold, such as Integer or String

Step 5: Set

- Allowable values section

You define if the parameter accepts a list, range, or all values

Step 6: Enter

- List of values or range fields

You provide the specific values or range the parameter can take

Step 7: Click

- OK button in Create Parameter dialog

The parameter is created and appears in the Data pane under Parameters

Before vs After

Before

No parameter exists; users cannot interactively change values on the dashboard

After

A parameter named 'Select Year' appears in the Data pane; users can pick a year to filter views

Settings Reference

Name

📍 Create Parameter dialog box

To identify the parameter clearly for use in calculations and filters

Default: Parameter 1

Data type

📍 Create Parameter dialog box

Defines the kind of values the parameter can hold

Default: Integer

Allowable values

📍 Create Parameter dialog box

Controls which values users can select or enter

Default: All

Current value

📍 Create Parameter dialog box

Sets the starting value of the parameter when the workbook opens

Default: First value or blank

Common Mistakes

Creating a parameter but not showing its control on the dashboard

Users cannot interact with the parameter if its control is not visible

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

Setting the wrong data type for the parameter

The parameter will not work correctly if its type does not match the expected input

Choose the data type that matches the field or calculation you want to control

Not linking the parameter to a filter or calculation

The parameter will have no effect on the dashboard without being used

Use the parameter in calculated fields or filters to make it functional

Summary

Parameters add interactive controls for users to change values on dashboards.

You create parameters by naming them, choosing data types, and setting allowed values.

Remember to show the parameter control and connect it to filters or calculations.

Practice

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

easy

A. To allow users to input a single value that can change calculations or filters

B. To store multiple values for grouping data

C. To create a static label on the dashboard

D. To automatically refresh data sources

Solution

1. Step 1: Understand what parameters do

   Parameters hold a single value that users can change to affect calculations or filters.

2. Step 2: Compare options with parameter purpose

   Only To allow users to input a single value that can change calculations or filters describes this interactive input feature correctly.

3. Final Answer:

   To allow users to input a single value that can change calculations or filters -> Option A

4. Quick Check:

   Parameter purpose = interactive single value input [OK]

Hint: Parameters hold one user-controlled value for interactivity [OK]

Common Mistakes:

• Thinking parameters store multiple values
• Confusing parameters with filters
• Assuming parameters refresh data automatically

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

easy

A. Double-click a worksheet title

B. Drag a field to Rows shelf

C. Use the Show Me panel to add a parameter

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

Solution

1. Step 1: Recall Tableau parameter creation steps

   Parameters are created by right-clicking in the Data pane and selecting Create > Parameter.

2. Step 2: Eliminate incorrect options

   Dragging fields or using Show Me does not create parameters; double-clicking titles edits text.

3. Final Answer:

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

4. Quick Check:

   Parameter creation = right-click Data pane [OK]

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

Common Mistakes:

• Trying to create parameters from Show Me panel
• Dragging fields instead of creating parameters
• Editing worksheet titles instead of parameters

3. Given a parameter named Sales Threshold set to 1000, and a calculated field High Sales defined as IF [Sales] > [Sales Threshold] THEN 'Yes' ELSE 'No' END, what will be the result for a sale of 1200?

medium

A. 'Yes'

B. 'No'

C. 1200

D. Error

Solution

1. Step 1: Understand the parameter and calculation

   The parameter Sales Threshold is 1000. The calculation checks if sales are greater than this threshold.

2. Step 2: Evaluate the condition for sale of 1200

   1200 > 1000 is true, so the calculated field returns 'Yes'.

3. Final Answer:

   'Yes' -> Option A

4. Quick Check:

   1200 > 1000 = 'Yes' [OK]

Hint: Compare value to parameter in IF statement for result [OK]

Common Mistakes:

• Confusing parameter value with sales value
• Expecting numeric output instead of text
• Ignoring the IF condition logic

4. You created a parameter but the dashboard does not update when you change its value. What is the most likely reason?

medium

A. The parameter control is hidden

B. The data source is disconnected

C. The parameter is not used in any calculated field or filter

D. The parameter value is set to automatic

Solution

1. Step 1: Understand parameter behavior

   Parameters alone do not affect the dashboard unless used in calculations or filters.

2. Step 2: Identify why dashboard doesn't update

   If the parameter is unused, changing it has no effect, causing no dashboard update.

3. Final Answer:

   The parameter is not used in any calculated field or filter -> Option C

4. Quick Check:

   Unused parameter = no dashboard update [OK]

Hint: Use parameters in calculations or filters to see changes [OK]

Common Mistakes:

• Assuming parameter control visibility affects updates
• Blaming data source connection without checking parameter use
• Misunderstanding parameter value settings

5. You want to create a parameter that lets users select a discount percentage from 0% to 50% in steps of 5%. Which parameter settings should you choose?

hard

A. Data type: Boolean; Allowable values: True or False

B. Data type: Integer; Allowable values: Range; Minimum: 0; Maximum: 50; Step size: 5

C. Data type: Float; Allowable values: All; Minimum: 0; Maximum: 50

D. Data type: String; Allowable values: List; Values: '0%', '5%', '10%', ..., '50%'

Solution

1. Step 1: Determine data type and value range

   Discount percentages are numeric integers from 0 to 50 with steps of 5.

2. Step 2: Choose parameter settings matching requirements

   Data type: Integer; Allowable values: Range; Minimum: 0; Maximum: 50; Step size: 5 correctly sets integer type, range values, and step size of 5.

3. Final Answer:

   Data type: Integer; Allowable values: Range; Minimum: 0; Maximum: 50; Step size: 5 -> Option B

4. Quick Check:

   Integer range with step size = correct parameter setup [OK]

Hint: Use integer range with step size for numeric selection [OK]

Common Mistakes:

• Using string type instead of numeric for percentages
• Choosing 'All' allowable values without step size
• Using Boolean type for numeric selection