Why parameters add user-driven flexibility in Tableau - Why Use It

Introduction

Parameters let users change values in a dashboard to see different results. This makes reports interactive and personalized without changing the data source.

When you want users to select a specific year to view sales data.

When users need to switch between different metrics like profit or revenue on the same chart.

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

When users should choose a region or category dynamically without multiple filters.

When you want to create a what-if analysis where users adjust assumptions.

Steps

Step 1: Click

- Data pane, then click the drop-down arrow next to Parameters

A menu appears with options related to parameters

Step 2: Select

- Create Parameter

The Create Parameter dialog box opens

Step 3: Type

- Name field in Create Parameter dialog

Parameter is named clearly, for example 'Select Year'

Step 4: Choose

- Data type and allowable values in the dialog

Parameter is set to accept specific values like integers or a list of years

Step 5: Click

- OK button in Create Parameter dialog

Parameter is created and appears in the Data pane under Parameters

Step 6: Right-click

- New parameter in Data pane

Context menu appears

Step 7: Select

- Show Parameter Control

Parameter control appears on the worksheet or dashboard for user interaction

Before vs After

Before

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

After

Dashboard includes a parameter control where users select a year, and charts update to show sales for that year only

Settings Reference

Data type

📍 Create Parameter dialog

Defines what kind of values the parameter accepts

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 blank

Common Mistakes

Not showing the parameter control after creating it

Users cannot interact with the parameter if the control is hidden

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

Using parameters without linking them to filters or calculations

Parameters alone do not change the data view unless used in calculations or filters

Use the parameter in calculated fields or filter conditions to make dashboards respond to user input

Summary

Parameters let users change values to explore data interactively.

They add flexibility by allowing input without changing the data source.

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