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.