What is a Dynamic Parameter in Tableau?

Nothing is more frustrating than building a beautiful Tableau dashboard, only to have the data become stale a week later. If you’ve ever used parameters, you know the drill: a new product gets added, a new sales region opens up, and suddenly you have to go back and manually update your parameter lists. This article will show you how to solve that problem for good by using one of Tableau’s most powerful features: dynamic parameters.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

You'll learn what a dynamic parameter is, why it's so helpful, and exactly how to build one step-by-step to keep your dashboards automatically updated and accurate.

First, What Are Tableau Parameters?

Before we can make a parameter dynamic, it helps to quickly recap what a parameter is in the first place. Think of a parameter as a container for a value that you or your end-users can change. It’s like a variable in your dashboard. You can use parameters to allow viewers to interact with the data and change the view without needing to use filters.

A classic example is creating a parameter to let a user switch the chart's primary metric. You could create a parameter called "Select a Metric" with a list of values like "Sales," "Profit," and "Quantity." The user selects "Profit," and the chart instantly updates to show profit data.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

The Problem With Standard Parameters

The issue with traditional parameters is that they are static. Once you define the list of values for the parameter, that list is set in stone. It doesn't know or care if the underlying data changes later.

Let's imagine you build a dashboard to analyze sales by Product Category. You create a parameter with a list of your current categories: "Furniture," "Office Supplies," and "Technology." Everything works perfectly until your company starts selling a new category, like "Appliances."

• Your dashboard will continue to show only the original three categories.
• "Appliances" will be missing from your parameter dropdown list.
• To fix it, you have to open the Tableau workbook, manually edit the parameter, add "Appliances" to the list, and then republish your dashboard.

This manual work is time-consuming, prone to error (it's easy to forget), and creates a constant maintenance headache. This is exactly where dynamic parameters come in.

The Solution: What Makes a Parameter “Dynamic”?

A dynamic parameter is a system that automatically updates its list of allowed values based on a column in your data source. Put simply, instead of you manually typing out a list of choices, Tableau does it for you by reading the unique values from a field you specify.

In our previous example, if we create a dynamic parameter based on the "Product Category" field, the moment "Appliances" appears in the data source, it will automatically appear in our parameter's dropdown list the next time the workbook is opened or refreshed. No manual editing required.

The key benefits of this feature are immediately clear:

• Always accurate dashboards: Your filters and controls will always reflect the latest data, eliminating confusion and ensuring users trust the report.
• Saves you time and effort: You can stop manually updating your workbooks every time the data changes. You build it once, and it maintains itself.
• Reduces human error: It’s impossible to forget to add a new value if the process is completely automated.
• Better user experience: Your audience gets a dashboard that just works, with access to all the data they need, as soon as it's available.

How to Create a Dynamic Parameter in Tableau: A Step-by-Step Guide

Let's walk through building a dynamic parameter from scratch. We'll use the classic "Sample - Superstore" dataset that comes with Tableau. Our goal is to create a dropdown menu that lets a user select a specific product Sub-Category to highlight, and we want this list to update automatically if new sub-categories are ever added.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Step 1: Create a New Parameter

First, we need to create the parameter itself and configure it to be dynamic.

1. In the Data pane on the left, right-click on any empty space and select Create Parameter... a new window will pop up.
2. Name your parameter something descriptive, like "Select Sub-Category."
3. Set the Data type to String, since the sub-category names are text.
4. Under Allowable values, select List. This is where the magic happens.
5. Instead of manually adding values from a list, find the section labeled When workbook opens. Click it.
6. From the dropdown menu that appears, find and select the field you want to dynamically pull values from. In our case, this is the Sub-Category field.

Your configuration should now tell Tableau to populate this parameter's list from the unique values in the "Sub-Category" field every time the workbook is opened. Click OK to create the parameter.

At this point, you'll see your new parameter at the bottom of the Data pane. If you right-click on it and select "Show Parameter," a dropdown list will appear on your canvas. It seems like it's ready, but it doesn't actually do anything yet. That’s because we haven't told Tableau how to use it.

Step 2: Connect the Parameter to a Filter or Calculation

A parameter on its own is just a variable sitting there waiting for instructions. To make it useful, we need to connect it to our visualization. The most common way to do this is with a calculated field that works as a filter.

1. Right-click in the Data pane again and select Create Calculated Field...
2. Let’s call this calculation "Sub-Category Filter".
3. The formula is very simple. We just want to check if the sub-category in our data matches the sub-category currently selected in our parameter. Type the following formula:

[Sub-Category] = [Select Sub-Category]

This calculation will go row by row through your data. If the [Sub-Category] for that row matches the value chosen in the [Select Sub-Category] parameter, it will return TRUE. Otherwise, it will return FALSE.

1. Click OK to save the calculated field.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Step 3: Build Your Chart and Apply the Filter

Now we just need to build a simple view and use our calculated field to filter it based on the parameter's selection.

1. Let's build a simple line chart. Drag Order Date (continuous MONTH) to the Columns shelf and Sales to the Rows shelf. You'll now see a line chart of sales over time.
2. Drag the calculation we just created, "Sub-Category Filter", from the Data pane onto the Filters shelf.
3. A filter dialog box will appear, asking which values to include. Check the box for True and click OK.
4. Finally, make sure your parameter control is visible. Right-click on your "Select Sub-Category" parameter in the Data pane and click Show Parameter.

That's it! You should now see a line chart and a dropdown menu. When you select different sub-categories from the dropdown (e.g., "Chairs," "Phones," "Binders"), the line chart will instantly update to show the sales trend for just that selection.

The best part? If your data gets refreshed with a new sub-category, it will automatically show up in that dropdown menu the next time you open the workbook. Your dashboard is now self-maintaining.

Practical Use Cases and Tips for Dynamic Parameters

This technique is useful far beyond filtering categories. Here are a few other ideas where dynamic parameters can save you a lot of time:

• Latest Date Filters: Create a dynamic parameter based on a date field to allow users to always select from the most recent dates available in the dataset.
• Customer or Product Lists: When analyzing data with frequently changing lists of customers, product SKUs, or campaign names, a dynamic parameter ensures the user can always find what they're looking for.
• "What If" Scenarios: Use a dynamic parameter to update a reference line for sales targets that change monthly. The parameter can pull the latest monthly target directly from the data.

A Few Pro Tips:

• Be Mindful of Refresh Times: Remember, the parameter list updates when the workbook is opened and the data source is refreshed. Clicking "Refresh" on the data source within Tableau Desktop will also update the parameter's values.
• Match Your Data Types: Ensure the data type of your parameter (String, Integer, Date, etc.) matches the data type of the field you're populating it from. A mismatch will cause errors.
• Setting a Default Value: In the parameter settings, you can define a "Value when workbook opens" to set a default selection. This is useful for ensuring the dashboard isn't blank when a user first opens it. You can either pick a specific value or tell it to use the "Current value," which is the last value that was saved with the workbook.

Final Thoughts

Dynamic parameters are a game-changer for anyone building dashboards in Tableau. They transform static, high-maintenance reports into living, self-maintaining tools that save you time, reduce errors, and deliver a better experience for anyone using your dashboards.

Mastering features like these in powerful BI tools is a valuable skill, but it often requires learning a lot of specific configurations just to keep reports from going stale. We built Graphed because we believe getting insights shouldn't require that level of manual upkeep or software-specific expertise. You simply connect data sources like Google Analytics, Shopify, or Salesforce, and then use plain English to ask questions and build dashboards. Your charts and reports are always live and update automatically, so you can focus on making decisions instead of constantly maintaining reports.