Tableau parameters are workbook variables that allow dashboard users to input values that dynamically change calculations, filters, and reference lines. This guide explains how Tableau parameters work, common use cases, and how they differ from filters.
A Tableau parameter is a workbook variable that stores a single value which users can change interactively. Parameters allow users to control aspects of the analysis — choosing a time period, selecting a metric to display, adjusting a forecast assumption — without the analyst needing to create separate worksheets or workbooks for each scenario.
Parameters differ fundamentally from filters. A filter restricts which data rows are included in the view; a parameter changes how data is calculated or displayed, independent of the underlying data. A filter on Region = "Northeast" excludes all non-Northeast rows; a parameter for "selected metric" changes whether the axis displays revenue, profit, or quantity — all the data remains available, but the parameter controls what is shown.
Parameter Data Types
Tableau parameters can be any data type:
- **Integer:** Selecting the top N customers to display (Top 10, Top 25, Top 50)
- **Float:** Adjusting a profit margin threshold for a reference line
- **String:** Choosing a dimension to display on the axis (customer segment, region, product category)
- **Boolean:** Toggling a comparison view on or off
- **Date:** Selecting a comparison period or cutoff date
The data type determines what kind of user input control is appropriate — a slider for integer and float parameters, a dropdown for string parameters with a fixed list of allowed values, a date picker for date parameters.
Common Parameter Use Cases
**Dynamic metric selection.** A parameter with allowed values of "Revenue", "Profit", and "Quantity" combined with a CASE-based calculated field allows a single dashboard to display any of the three metrics based on user selection. Without parameters, this requires three separate sheets or filters — the parameter makes the dashboard more flexible without multiplying the number of views.
**Adjustable reference lines.** A reference line showing a target or threshold value (target revenue of $1M, acceptable response time of 200ms) can be driven by a parameter rather than a hardcoded value. The user adjusts the target parameter and the reference line moves accordingly — useful for what-if analysis.
**Top N filtering.** A parameter controlling the number of top items to display ("show top N customers by revenue") combined with a top N filter that uses the parameter value allows users to interactively change the granularity of a bar chart from top 5 to top 20 without changing the underlying filter.
**Date comparison periods.** A date parameter allows users to select the comparison period for period-over-period analysis — comparing current period to prior year same period, prior quarter, or a user-selected date range.
**What-if scenario analysis.** Financial models that show projected revenue under different growth assumptions can use a float parameter for growth rate. The user adjusts the growth rate parameter and the projected revenue line updates — a simple planning tool built within Tableau without a separate financial model.
**Dynamic axis scaling.** A parameter can control whether a chart uses a fixed axis scale or a dynamic scale, or can let the user set the axis maximum for consistent cross-chart comparison.
Creating and Using Parameters
Parameters are created in Tableau Desktop through the Data pane (right-click, Create Parameter) or through the Analysis menu. Each parameter definition includes:
- Data type
- Current value (the default shown when the workbook opens)
- Allowable values: all, list, or range
- For list type: the specific allowed values and their display labels
To make a parameter user-visible, right-click the parameter in the Data pane and select "Show Parameter Control." Tableau displays the parameter control — a slider, dropdown, or text input depending on data type and configuration — as a floating element that can be placed on dashboards.
Parameters become analytically useful when referenced in calculated fields. A calculated field using IF [Selected Metric] = "Revenue" THEN [Revenue] ELSEIF [Selected Metric] = "Profit" THEN [Profit] ELSE [Quantity] END creates a dynamic measure that responds to the parameter value. Place this calculated field on the Rows shelf, and the view updates whenever the user changes the parameter.
Parameters vs Sets vs Filters
Three Tableau mechanisms control what is shown in views; each has a distinct purpose:
**Filters** restrict which data rows are included. Applied to a dimension, a filter removes specific members from the view. Applied to a measure, a filter excludes rows outside a value range. Filters operate on data inclusion.
**Sets** define custom subsets of dimension members that can be used as a dimension or filter — "Top 10 customers by revenue" as a set, used to split all charts into in-set and out-of-set groups. Sets are data-defined groupings.
**Parameters** change calculation logic or display behavior. They do not restrict data directly; they change how existing data is processed or displayed. Parameters operate on analysis logic, not data inclusion.
Our Tableau consulting services include advanced Tableau development — parameters, calculated fields, LOD expressions, and interactive dashboard design. Contact us to discuss your Tableau development requirements.
A former Microsoft data architect audits your data foundation, identifies your top priorities, and sends you a written plan. Free. No pitch.
Book a Call →