How to Use a Parameter as a Filter in Tableau

Building a Tableau dashboard is one thing, but building one that feels interactive and intuitive for your audience is another entirely. If you want to give your users more control and flexibility, you need to go beyond the standard "Quick Filter" and start using parameters. This guide will walk you through exactly how, why, and when to use a parameter as a filter to create more dynamic and powerful visualizations.

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

We'll cover two of the most popular and impactful use cases: building a "Top N" filter to let users see your best (or worst) performers and creating a dynamic dimension filter so users can swap out the categories they're viewing entirely.

First, Why Use a Parameter Instead of a Standard Filter?

You might be wondering why you can't just use a regular filter. Quick Filters are great for simple, single-field filtering, like letting a user show data for only the "West" region or the "Technology" category. But they are rigid, a filter for the Region field can only ever filter by region.

Parameters break free from these limitations. A parameter isn't tied to any specific field in your data source. Instead, it’s a placeholder value that you (or your user) can change. That value can then be used in calculations, which gives you incredible control over your dashboard's behavior.

Using parameters for filtering allows you to:

• Create a "Top N" view: Let users decide if they want to see the top 5, 10, or 25 products by sales.
• Swap Dimensions and Measures: Let users choose whether to view sales by Region, Category, or Customer Segment, all within the same chart.
• Perform What-If Analysis: Build input boxes where users can test scenarios, like a hypothetical sales increase or a budget change, and see its impact instantly.
• Filter Across Data Sources: A single parameter can influence worksheets that are built on completely different data sources, something a standard filter cannot do.

Let's dive into the practical steps for two essential parameter-driven features.

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

How to Build a "Top N" Parameter Filter

One of the most common requests from stakeholders is to see the "top performers." Are they the top 10 products? Top 5 sales reps? Top 20 landing pages? With a parameter, you can let them decide on the fly instead of creating a separate chart for each request.

For this example, imagine you have a bar chart showing Sales by Product Name, and you want to let the user control how many products are displayed.

Step 1: Create the Parameter

First, you need to create the parameter that will store the "N" value (e.g., 5, 10, 20).

1. In the Data pane on the left, right-click anywhere in the blank space and select Create Parameter...
2. A configuration window will pop up. Fill it out like this:
3. Click OK. You'll now see your shiny new parameter appear in the bottom section of the Data pane.

Step 2: Connect the Parameter to a Filter

Just creating a parameter doesn't do anything on its own. Now we need to tell Tableau how to use it. We'll do this by creating a filter on the field we want to rank - in this case, Product Name.

1. Find the dimension you want to filter (Product Name) in your Data pane.
2. Drag Product Name directly onto the Filters card.
3. The Filter window will open. Go to the Top tab along the top.
4. Select the option for By field:.
5. This is the key step. By default, the dropdown next to "Top" will be set to 10. Click this dropdown, and you'll see your [Top N Products] parameter listed at the bottom. Select it!
6. For the last part of the configuration, make sure the filter knows what to rank by. Confirm it says by Sales and the aggregation is Sum.
7. Click OK.

Your view will instantly update to show the Top 10 products (or whatever default value you set for the parameter). But it's not yet interactive for the user.

Step 3: Show the Parameter Control

The final step is to put the control on the screen so your audience can interact with it.

1. Go back to the Data pane and find the [Top N Products] parameter.
2. Right-click on it and select Show Parameter.

A small control box will appear on the right side of your worksheet. A user can now type a number into the box or use the slider to change the value, and the bar chart will dynamically update to show the corresponding number of top products. You've successfully built an interactive Top N filter!

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

How to Let Users Switch Dimensions with a Parameter

This is another high-impact technique. Let's say you have a single bar chart showing Sales. Do you show it by Region? By Product Category? By Shipping Mode? Why not let the user decide? A parameter lets you build one versatile chart instead of three separate ones.

Here's how to build a view where users can swap the dimension on a chart's axis.

Step 1: Create the Parameter to Select a Dimension

This parameter will hold the user's choice of what dimension they want to see.

1. Right-click in the Data pane and select Create Parameter...
2. Configure the settings:
3. Click OK. The parameter now exists in the Data pane.

Step 2: Create a Calculated Field to Act on the Parameter

This step is the "magic" that connects your abstract parameter to your actual data fields. We need a calculation that checks the parameter's current value and, based on that, returns the corresponding data field from your data source.

1. Right-click in the Data pane and select Create Calculated Field...
2. Name it something clear, like Dynamic Dimension.
3. In the formula editor, use a CASE statement. A CASE statement is perfect for this, as it checks a single field (our parameter) against multiple possible values.

The calculation looks like this:

CASE [Select a Dimension]
    WHEN "Category" THEN [Category]
    WHEN "Region" THEN [Region]
    WHEN "Ship Mode" THEN [Ship Mode]
END

Let's break that down:

• CASE [Select a Dimension] tells Tableau to look at the value of your parameter.
• WHEN "Category" checks if the user selected "Category" from the dropdown.
• THEN [Category] says, "If they did, then return the actual [Category] dimension from the data."

Essentially, this calculated field dynamically becomes either the [Category], [Region], or [Ship Mode] dimension based on the user's choice. Click OK to save it.

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 the View and Show the Parameter

Now all you need to do is build your chart using this newly created calculated field instead of a static dimension.

1. Drag your new [Dynamic Dimension] field from the Data pane onto the Columns shelf.
2. Drag a measure, like SUM(Sales), onto the Rows shelf.
3. Right-click on your [Select a Dimension] parameter in the Data pane and select Show Parameter.

Your interactive chart is complete! Now when a user selects "Region" from the parameter dropdown, the calculated field returns the Region values, and the chart axis updates accordingly. This is a remarkably efficient way to add depth to your dashboard without cluttering it with multiple worksheets.

Final Thoughts

Mastering parameters takes your Tableau skills from static reporting to creating genuinely interactive analytical tools. By allowing users to control "Top N" rankings or swap the dimensions they analyze, you empower them to explore the data for themselves and uncover insights that a predefined chart might have missed.

While building this kind of interactivity in tools like Tableau is powerful, it often involves a steep learning curve and several manual steps for each dashboard. We designed Graphed to remove this friction entirely. Instead of creating parameters, calculated fields, and configuring filters, you can just ask a question in plain English like, "show me a bar chart of my top 15 products" or "compare revenue by campaign for last month." Our AI analyst handles all the setup in seconds, creating real-time, interactive dashboards without you needing to touch a single configuration menu.