How to Show Parameter in Dashboard Tableau
Tableau parameters are one of an analyst's best tools for turning static dashboards into dynamic, interactive experiences for your audience. Instead of creating a dozen different views, you can build one versatile dashboard and let users explore the data themselves. This guide will walk you through exactly how to create a parameter and, more importantly, display that interactive control on your Tableau dashboard.
What is a Tableau Parameter?
Think of a Tableau parameter as a variable that you and your users can change. It’s a placeholder value - like a specific date, a number, or a piece of text - that you can incorporate into your calculations, filters, and reference lines. Unlike a filter, which directly subsets your data, a parameter is an independent value that doesn't do anything on its own. Its real power comes when you connect it to your analysis.
Here are a few common ways parameters are used:
- Top N Analysis: Allow users to see the Top 5, Top 10, or Top 20 products by sales.
- What-If Scenarios: Let users input a percentage to see how a projected sales increase or budget cut would affect overall numbers.
- Metric Swapping: Give users a control to switch a chart's metric between Sales, Profit, and Quantity.
- Reference Lines: Set a dynamic goal line on a chart that a user can adjust to see performance against different targets.
The key takeaway is that parameters give control to the end-user, letting them answer their own questions without needing you to build a new report for every request.
Step 1: Create the Parameter in Your Worksheet
Before you can show a parameter on a dashboard, you have to create it first. Let’s build a common and very useful example: a parameter that lets the user switch the measure being displayed on a chart.
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.
Define the Parameter Itself
We'll create a simple line chart showing performance over time and allow the user to switch between viewing Sales, Profit, and Quantity.
- In your Tableau worksheet, find the Data pane on the left side. Right-click anywhere in the empty space below your fields and select Create Parameter...
- This opens the Create Parameter dialog box. Let's configure it:
You’ll now see your new "Select a Metric" parameter in the bottom section of the Data pane. If you right-click on it and select "Show Parameter," a little control box will appear on the right side of your worksheet. You can click the options, but you'll notice nothing on your chart changes yet. That's because the parameter isn't connected to anything.
Link the Parameter With a Calculated Field
This is the magic step. We need to create a calculated field that tells Tableau what to do when a user selects an option from the parameter.
- Right-click in the Data pane again and select Create Calculated Field...
- Name this calculation something like "Selected Metric Value".
- Now, we'll write a simple
CASEstatement. This statement tells Tableau: "Look at the current value of the 'Select a Metric' parameter. If it's 'Sales', then use the [Sales] field. If it's 'Profit', use the [Profit] field," and so on.
Here’s the formula:
CASE [Select a Metric] WHEN "Sales" THEN [Sales] WHEN "Profit" THEN [Profit] WHEN "Quantity" THEN [Quantity] END
- Click OK.
You now have a new measure called "Selected Metric Value". This field is dynamic, its value will change based on whatever the user picks from the parameter control.
Use the New Calculation in Your View
Finally, drag your new calculated field, "Selected Metric Value", onto the Rows shelf, replacing whatever static measure you had there before. Drag a date field (like Order Date) to the Columns shelf.
Now, when you use the "Select a Metric" parameter control on the side of your worksheet, the line chart will update instantly. You’ve successfully created an interactive chart!
Step 2: Show the Parameter Control on Your Dashboard
Now for the main event. Getting the parameter control to show up on your finished dashboard is incredibly straightforward.
- Create a new dashboard or navigate to an existing one.
- From the list of sheets on the left, drag the worksheet you just built (the one with the interactive line chart) onto your dashboard canvas.
- Your chart will appear, but where’s the control? You just have to tell Tableau you want to see it.
That's it! The "Select a Metric" control panel will instantly appear on your dashboard, ready for users to interact with. By default, Tableau usually adds it as a tiled object on the right side.
Step 3: Customizing Your Dashboard Parameter
Just showing the parameter is one thing, but making it intuitive and user-friendly is what separates a good dashboard from a great one. Once the parameter control is on your dashboard, you can customize how it looks and functions.
Click on the dropdown arrow at the top of the parameter control itself (not the worksheet). Here you have several options:
- Edit Title...: By default, the title matches the parameter's name. You can edit this to be a more direct question, like "Choose a Metric to Display"
- Display Format: You can change how the user interacts with the selections.
- Floating vs. Tiled: By default, objects are "Tiled", meaning they snap into a grid. If you want to place your parameter control in a very specific location, you can switch it to "Floating" and drag it exactly where you want it, even on top of other objects if needed.
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.
Common Troubleshooting: "My Parameter Isn't Working!"
If you've added the parameter to your dashboard but nothing happens when you interact with it, the cause is almost always the same: the parameter isn't linked to your worksheet correctly.
Remember, a parameter is just a boat. A calculated field or a filter is the engine that makes the boat move. Go back to your original worksheet and make sure that:
- You have created the associated calculated field that uses the parameter (like our
CASEstatement example). - You are actually using that calculated field in your chart (e.g., on the Rows, Columns, or Color shelf). This is the most common mistake. Many people create the calculation but forget to drag it into the view.
Go back, swap out your static field for the dynamic calculated field, and your parameter on the dashboard will come to life.
Final Thoughts
Showing parameters in a Tableau dashboard is all about giving your audience the power to explore. By creating a parameter, tying it to a calculation, and adding that control to your dashboard, you can build powerful, dynamic reports that answer dozens of business questions in a single view.
This process, while powerful, highlights the multi-step effort involved in traditional BI tools, from manual parameter creation to writing calculated fields. At Graphed, we've focused on eliminating that complexity entirely. We designed a platform where you can create interactive dashboards by just describing what you need in plain English - no calculated fields or menus required. Instead of building it step-by-step, you can just ask, "Show me a chart comparing sales and profit over time," and the interactive chart is built for you, letting you get straight to the insights.
Related Articles
Facebook Ads for Salons: The Complete 2026 Strategy Guide
Learn how to run profitable Facebook ads for hair salons and beauty spas in 2026. This comprehensive guide covers targeting, ad creation, budgeting, and proven strategies to attract more clients.
Facebook Ads For Beauty Salons: The Complete 2026 Strategy Guide
Learn the proven Facebook ad strategies that successful beauty salons are using to attract new clients, increase repeat bookings, and grow their revenue in 2026.
Facebook Ads for Wedding Planners: The Complete 2026 Strategy Guide
Learn how to use Facebook ads to book more wedding planning clients in 2026. Complete guide covering targeting, budgets, retargeting, and conversion strategies.