Parameters

Making your charts dynamic and user-controlled

9 minutesVideo LessonPDF notes

🎯 Free Guest Mode: You are learning for free. Sign in to save your completion progress and quiz answers.

Ready to continue?

Mark this lesson as complete when you're ready to proceed.

Key moments

Parameter Definition — Introduces parameters as global variables across multiple supported data types.
Creating a Parameter — Demonstrates creating a float parameter, setting default formats, and displaying the control.
Allowable Values and UI — Explains how choosing All, List, or Range alters interactive UI input options.
Dynamic Threshold Use Case — Builds a dynamic sales threshold calculation to re-color bar charts interactively.
Dynamic Top-N Ranking — Combines RANK with an integer parameter to build an interactive Top-N display filter.

PDF notes

Bottom line: You will create and configure dynamic parameters across multiple data types and allowable value constraints in Tableau. You will integrate these parameters into calculated fields to build dynamic threshold coloring and interactive Top-N ranking filters.

This lesson on Parameters is hands-on and example-driven. You will create and configure dynamic parameters across multiple data types and allowable value constraints in Tableau. You will integrate these parameters into calculated fields to build dynamic threshold coloring and interactive Top-N ranking filters.

What You'll Be Able To Do

Create parameters using data pane menus, field context menus, and empty sidebar areas
Configure allowable value constraints including All, List, and Range with custom step sizes
Select appropriate user-facing control interfaces such as single-value lists, sliders, compact lists, and type-in boxes
Write conditional calculated fields referencing parameter values to dynamically re-color visualizations
Build a dynamic Top-N filter using the RANK table calculation evaluated against an integer parameter

Detailed Concept Walkthrough

1. Parameter Fundamentals and Definition

A parameter acts as a global workbook variable that supplies a dynamic value to calculations, filters, and reference lines without modifying underlying data structures.

Mechanism: Parameters are instantiated via the Data pane dropdown, right-clicking a field, or right-clicking empty space in the sidebar. When created from an existing field, the parameter automatically inherits that field's underlying data type and domain range.
Under the Hood: Unlike calculated fields or dimensions, a parameter holds a single scalar value globally across the entire workbook. When a user updates the parameter control, Tableau pushes the new scalar value into all dependent calculations and triggers a view re-render.
Syntax Rule: Parameters require a explicit data type (Float, Integer, String, Boolean, Date, or Date & Time) and an initial current value upon workbook load.
Best Practice: Set default display formats (such as Currency for monetary values) directly in the parameter definition to maintain clean UI controls.

// Parameter Definition Schema (Conceptual/Workbook XML Reference)
// Name: [Sales Parameter]
// Data Type: Integer
// Current Value: 10000
// Allowable Values: Range (Min: 10000, Max: 200000, Step Size: 10000)
// Display Format: Currency ($)

Key Takeaway: Parameters provide symbolic, globally accessible variables that decouple user inputs from hardcoded calculation logic.

2. Allowable Values and Control Types

The allowable value constraint defined on a parameter strictly dictates the interactive UI controls exposed to the end user.

Mechanism: Setting allowable values to 'All' permits unconstrained user typing matching the data type. Restricting to 'List' allows specific predefined values, while 'Range' enforces numeric or date boundaries with specific step intervals.
UI Control Mapping: 'List' values enable Radio Button Lists, Compact Lists (dropdowns), Sliders, and Type-In interfaces. 'Range' values restrict options to Sliders or Type-In, whereas 'All' forces a simple Type-In box.
Type Enforcement: Input interfaces enforce data types strictly at runtime; typing non-numeric text into a Float or Integer parameter control will reject the entry and keep the previous valid value.
Date Controls: Date data types automatically generate calendar picker widgets and formatted date input controls in the workbook interface.

// Allowable Values Control Matrix:
// All    -> Type In
// List   -> Single Value (Radio), Compact List (Dropdown), Slider, Type In
// Range  -> Slider, Type In (enforces Min, Max, Step)

Key Takeaway: Choosing the appropriate allowable value constraint determines the input widgets available on your dashboard.

3. Dynamic Threshold Categorization

Substituting static constants with parameters inside conditional statements creates responsive visual categorization and dynamic grouping.

Mechanism: Conditional logic evaluates aggregated measures against the scalar value supplied by a parameter control. Modifying the parameter automatically shifts marks across conditional branches without editing the calculation.
Execution Flow: When a user adjusts the parameter slider, Tableau recalculates the conditional evaluation per mark in the view and updates the corresponding Color shelf encoding immediately.
Best Practice: Use parameters instead of hardcoded numbers in boolean or IF-THEN statements to prevent repetitive calculation maintenance.

// Calculated Field: [Sales Group]
// Compares aggregated sales against dynamic threshold
IF SUM([Sales]) > [Sales Parameter] THEN
    "Above"
ELSE
    "Below"
END

Key Takeaway: Dynamic threshold calculations replace hardcoded constants with parameter references for real-time visual recalculations.

4. Top-N Filtering via Table Calculations

Combining an integer parameter with the RANK table calculation allows users to dynamically control the number of displayed records.

Mechanism: The RANK function assigns ordinal rankings (1 being highest) to aggregated measures across dimensions. A boolean or string evaluation flags whether each rank falls within the threshold defined by the parameter.
Execution Flow: The ranking calculated field is placed on the Filters shelf with the filter condition set to keep only 'Show' marks, dynamically reducing view density as the parameter changes.
Under the Hood: Table calculations execute on the aggregated query results returned to Tableau's local engine, allowing instant Top-N filtering without re-querying the raw data source.

// Calculated Field: [Rank Sales]
// Ranks states and checks against user-selected Top-N threshold
IF RANK(SUM([Sales])) <= [Sales Top N Parameter] THEN
    "Show"
ELSE
    "Hide"
END

Key Takeaway: Evaluating RANK against an integer parameter provides an interactive Top-N display filter powered by local table calculations.

Topics Covered in Parameters

Parameter Definition (0:00 - 0:35) — Introduces parameters as global variables across multiple supported data types.
Creating a Parameter (0:35 - 1:20) — Demonstrates creating a float parameter, setting default formats, and displaying the control.
Allowable Values and UI (1:20 - 2:30) — Explains how choosing All, List, or Range alters interactive UI input options.
Dynamic Threshold Use Case (2:30 - 3:50) — Builds a dynamic sales threshold calculation to re-color bar charts interactively.
Dynamic Top-N Ranking (3:50 - 5:15) — Combines RANK with an integer parameter to build an interactive Top-N display filter.

Reference Cheat Sheet

IF SUM([Field]) > [Param] THEN ... END — Evaluates aggregate values dynamically against a parameter threshold
```
IF SUM([Sales]) > [Minimum Sales Parameter] THEN "Above" ELSE "Below" END
```
RANK(SUM([Field])) — Calculates ordinal rank of aggregated values descending
```
RANK(SUM([Sales]))
```
IF RANK(SUM([Field])) <= [Param] THEN ... END — Generates a conditional flag for Top-N filtering
```
IF RANK(SUM([Sales])) <= [Sales Top N Parameter] THEN "Show" ELSE "Hide" END
```
Right-Click Parameter -> Show Parameter — Displays the interactive parameter control on the sheet

Comparison Table

Allowable Value Setting	Available UI Control Types	Input Restrictions
All	Type In only	Constrained only by data type
List	Radio List, Dropdown, Slider, Type In	Restricted to explicitly defined values
Range	Slider, Type In	Restricted to Min, Max, and Step

Common Pitfalls

Mistake: Creating a parameter but forgetting to show the parameter control on the view. Avoid: Right click the parameter in the Data pane and select Show Parameter.
Mistake: Creating a parameter and expecting it to filter data automatically without referencing it. Avoid: Write a calculated field referencing the parameter and add it to Filters or Marks.
Mistake: Typing non-numeric values into a Float or Integer parameter control. Avoid: Match the input data type or change the parameter definition to String.

FAQs

Why does changing my parameter have no effect on the visualization? Parameters do nothing on their own until referenced inside a calculated field, filter, or reference line in the active view.
Can I use text strings in a Range parameter? No, Range allowable values are only available for numeric (Float, Integer) and Date data types.
What happens when a parameter is created directly from an existing field? It automatically inherits the field's data type, allowable domain range, and default formatting.

Common pitfalls

Mistake: Creating a parameter but forgetting to show the parameter control on the view. Avoid: Right click the parameter in the Data pane and select Show Parameter.
Mistake: Creating a parameter and expecting it to filter data automatically without referencing it. Avoid: Write a calculated field referencing the parameter and add it to Filters or Marks.
Mistake: Typing non-numeric values into a Float or Integer parameter control. Avoid: Match the input data type or change the parameter definition to String.

In this video, we will go through what is a parameter in Tableau, how to create a parameter and some use cases for parameters. A parameter in Tableau is equivalent to any programming languages' use of a variable, and a variable is just a symbolic way to reference a particular value. This parameter can be a number, a date, a string or a Boolean value, which is a true or false value. So, by defining a parameter in Tableau, you can reference it in calculated fields and change the outcome of the calculated fields without actually editing the field itself. Now, let's jump right into creating some parameters. The simplest way to create a parameter is to click on this downwards arrow here and then create parameter. Or we can select one of the fields and then right-click to create a parameter. Or we can right-click on an empty space in this left sidebar and then create parameter. So, for all parameters, we need to give it a name and we'll name this parameter "Minimum Sales Parameter", and then define a data type. So, choosing from the drop-down menu here. And since we'll use this later on to determine the sales that are greater than this parameter value, we'll keep it as a float value. And then we can also uh change the allowable values to either have accept all values or a list of values we define. So, we can change these, or have like a range of values going from 1 to maybe 50 with a step size of 1. But now, we'll just change uh we'll just keep this as all as a demonstration. And then, if we want to change the format of how this parameter is displayed, then we can sli- select uh drop-down menu here and then change how this number is displayed. So, we know the sales are going to be a currency, so we can change that to a currency. And then, when this workbook opens, it will take on the current value and still currently it's just one, so that's what it will take on. And then when we click "OK", we'll be done creating our first parameter. And then, if we want to change the value of the parameter, we just hit the right-click and then "Show Parameter", so that it's shown on our view, and then we can change the parameter from here. And one last thing is that if we create a parameter from one of the fields, then it will take on the range of value that that field has. So for sales, the range of values for sales was from 0.444 to 22,600 approximately. But although it's inheriting this range of values, we can also change this to have allow all values if we wanted to. The next thing we're going to go through is the options to interactively change the parameter values. So, depending on what type of allowable values you select, your options will change. What I mean by this is if we edit this and select uh allowable values as a list, here I'll just type in a couple numbers, and then we can see that if we click the downwards arrow here, we have a couple of options where it will show how you can interactively change the values. So, a single value list is just radio button list. A compact list is just a list shown this way. A slider is exactly what it sounds like, just a slider for you to change your values. And then a type in is just you typing in your values. And then if we change this to a range of values, we have different options. So, we only have the slider or type in option. And we have the least options when we have when we choose the allowable values as all because Tableau can't tell what kind of like values that you have. So, it just allows type ins. So, if your parameter data type is a float, you'll only be able to type in numbers. So, if we try to type in "Tableau" in here, nothing happens and the value won't change because it only accepts float numbers. So, for your data types for float and integers, it only accepts numbers. For strings, it can accept any value. And then for Boolean, it's just true or false. And then for a date, it's just calendar values. So, we can show what date would look like. It will give you a calendar that you can select a value from or you can type it in specifically and change the year. Now that we know how to create and change parameters, I'm going to show you some example use cases with parameters. So here in this view, we have a bar chart showing the total sales for each state, and I want to see which states have sales greater than $10,000, and which states have less. What we can do is create a calculated field, which I've done here, called "Sales Group". That's essentially a conditional statement, so if the sum of sales is greater than $10,000, then it is above or else it's below. And we can drag this calculated field uh to the color marks, and we can see that for the bars that are blue, they're greater than 10,000 and then for the bars that are orange, they're less than 10,000. But now, what if we wanted to see the states that have more than 50,000? What we would have to do is go back into the Sales Group calculated field and change this value because it is fixed. This can be very tedious if you want to use this in a dashboard. So, what we can do instead of hardcoding a number in is we can input a parameter that references a value that can be easily changed on this right sidebar here. So, my parameter is called "Sales Parameter", which is what I'm going to put into here. And I'll show you exactly what the Sales Parameter is by editing it here. So, it is an integer type with the current value at $10,000, and it has a range of values from 10,000 to 200,000 with step sizes of 10,000. So, when we're when we change this parameter, we can see that the bar chart changes as well and the range changes. So, this is a dynamically changing calculated field, which is a lot more intuitive and if you wanted to make changes, it's a lot easier to do. So, this is just a very simple use case of parameters, but there are many other applications for using parameters as it helped make your workbooks a lot more interactive. Next, we'll go through a ranking use case with parameters. We have the same view as before, so a bar chart showing the total sales for each state and province. And if we wanted to see the top five best-selling states, what we can do is create another calculated field, which I've done here, called "Rank Sales". And it's another conditional statement. So, if the rank of the sum of sales is less than or equal to our sales top end parameter, then show, otherwise hide. And this parameter is just an integer value that's stating maybe we want to see our top 10 or top 15, and we can change that. So, I'll show you the result of this first, then go through the creation of the parameter. And here on the right side, you can see that our parameter value is 10. So theoretically, when we move this into the color, we will see the top 10 best-selling states as orange. What we can do is if we want to only see those 10 states, we can just drag it into filters and then just show, so we only see these top 10 best-selling states. And for clarity, we can have the sum of sales as a label and then also another thing we can do with sales is since we know that it's a currency, we can change the default property of the format to currency, so every time we drag it into the view, it'll be a currency, and we can see that these have changed to all currencies. And now, let's go through how this parameter was made. So, this parameter is just an integer value uh data type with the current value being 10, and the minimum is 1 to 50, which is a range of values. And also the good thing about this is when it's a filter, you can filter for how many you want to see. So, since uh we had it as 10 before, if you drag it to like another number, we'll only be able to see like the top 20 or top 10, or however many we want to see. So, we can also take a look at how this ranking works. And what I've done here in the sheet is created a calculated field that's just the rank of sum of sales, which is the expression we had in the rank of sales. And what that does is it just ranks the sales based off of which one's the highest. So, the highest one would be rank one, and the lowest one would be rank 59. And this example concludes this parameters in Tableau video, and stay tuned for a future video where I'll go through more advanced parameter use cases. I hope this video was useful for you, and thank you for watching. If you enjoyed this video and want to be updated every time I post a new video, I would love for you to subscribe to me. I post a new video every Thursday.

Frequently asked questions

Why does changing my parameter have no effect on the visualization?

Parameters do nothing on their own until referenced inside a calculated field, filter, or reference line in the active view.

Can I use text strings in a Range parameter?

No, Range allowable values are only available for numeric (Float, Integer) and Date data types.

What happens when a parameter is created directly from an existing field?

It automatically inherits the field's data type, allowable domain range, and default formatting.

How was this lesson?

Your feedback helps us refine explanations and catch bugs.