Graphed LogoGraphed
Graphed LogoGraphed
How It WorksAgentsIntegrationsPricing

What is Parameter Action in Tableau?

Cody Schneider••8 min read

Parameter actions in Tableau transform a static dashboard into an interactive, app-like experience for your audience. Instead of relying on dropdown menus and sliders, you can let users change key values simply by clicking on the visualization itself. This guide will walk you through exactly what parameter actions are, why they're so powerful, and how to build one step-by-step.

GraphedGraphed

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.

Watch Graphed demo video

What is a Parameter Action in Tableau?

To understand a parameter action, you first need to be familiar with parameters. In Tableau, a parameter is a dynamic placeholder for a value. Think of it as a variable that you or your end-user can control, allowing you to pass a specific value into calculations, filters, or reference lines. For example, you could have a parameter for a sales target, and a user could adjust it with a slider to see how performance measures up against different goals.

A parameter action takes this a step further. It's a type of dashboard action that allows users to change a parameter's value by interacting directly with a viz. Instead of manually adjusting a control, a user can click on a data point, an axis label, or a specific mark, and that interaction will automatically update the parameter's value with data from the visualization.

This simple mechanism unlocks a massive range of possibilities, turning your dashboards from something your users look at to something they can truly engage with.

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.

The Key Difference: Direct vs. Indirect Interaction

The traditional way to change a parameter's value involves using a separate control object on your dashboard. This works, but it can feel clunky and disconnected from the data itself. The user has to find the control, understand what it does, and then adjust it. A parameter action creates a more intuitive and seamless experience. The interaction happens right where the user's attention is focused: on the chart itself.

Why Use Parameter Actions? Key Benefits and Examples

Parameter actions are more than just a novelty, they solve practical problems and enable more sophisticated user-driven analysis. Here are a few powerful ways to use them in your dashboards.

  • Dynamic Reference Lines: Let users click on any data point in a time series chart to set it as a benchmark. This allows for instant period-over-period comparison without needing to hardcode a specific date or value.
  • "Drill Down" and "Drill Up" Experiences: You can create asymmetrical drill-downs. For instance, a user could click on a "Category" bar (like 'Furniture') in a bar chart to see its "Sub-Categories" appear next to it, while the other categories remain collapsed. This gives you more control over the user journey than standard hierarchies.
  • Interactive Chart Highlighting: Give your user the ability to highlight all data points that share a common attribute. For example, clicking on a state in a map could highlight every customer from that state in a separate scatter plot.
  • Measure and Dimension Swapping: You can build worksheets that act as buttons. Clicking on "Sales" could show a sales trend, while clicking "Profit" would swap out the sales chart for a profit chart within the same container.
  • "What-If" Analysis: By tying parameters to calculations, you can empower users to model different scenarios. For example, a user could click on a product to apply its specific discount rate to a forecast of overall revenue.

A Step-by-Step Guide to Creating a "Click to Change" Reference Line

Let's walk through one of the most common and useful applications of parameter actions: building a dynamic reference line. In this scenario, we’ll build a line chart showing sales over time. Our goal is to let a user click on any data point (representing a month's sales) to set a reference line at that exact value, making it easy to see which other months were above or below that selection.

Step 1: Build the Basic View

First, create a simple line chart. For this example, we'll use Tableau's Sample Superstore dataset.

  1. Drag Order Date to the Columns shelf. Right-click the pill and choose the continuous "Month" option (the one with a green calendar icon).
  2. Drag Sales to the Rows shelf. This will automatically become SUM(Sales).

You should now have a basic line chart showing total sales across months.

Step 2: Create the Parameter

Next, we need a parameter to store the selected sales value. This is the placeholder that our action will update.

  1. In the Data pane (on the left), right-click in an empty space and select Create Parameter...
  2. Name the parameter clearly. Let's call it "Selected Sales Value".
  3. Set the Data type to Float. 'Float' is a data type for numbers that can have decimal points, making it a safe choice for sales data.
  4. For Allowable values, keep it set to All. This allows any numeric value to be passed into the parameter.
  5. Click OK. You'll see "Selected Sales Value" appear in the parameters section at the bottom of the Data pane.
GraphedGraphed

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.

Watch Graphed demo video

Step 3: Add the Parameter as a Reference Line

Now, we'll add a reference line to our chart and have its value be controlled by our new parameter.

  1. Go to the Analytics pane (next to the Data pane).
  2. Drag Reference Line from the pane and drop it onto the chart canvas. Choose the SUM(Sales) axis.
  3. In the "Edit Reference Line" dialog that appears:
  4. Apply some formatting to make the line stand out (e.g., a dashed red line). Click OK.

At this point, you won't see much change, because the parameter's value is still at its default (likely 0). The magic happens in the next step.

Step 4: Create the Parameter Action

This is where we connect the user’s click to the parameter we created. The action will "listen" for a click and send the sales value of the clicked data point to our "Selected Sales Value" parameter.

  1. From the top menu, go to Worksheet > Actions... (if you're on a worksheet) or Dashboard > Actions... (if you placed this sheet on a dashboard).
  2. In the Actions window, click Add Action >, and then select Change Parameter...
  3. Give your action a descriptive name, like "Update Sales Value on Click".
  4. Under Source Sheets, ensure only the worksheet with your line chart is checked.
  5. Set Run action on to Select. This means the action will fire when a user clicks a mark.
  6. Under Target, do the following:
  7. For Clearing the selection will:, choose Keep current value. This is a key step! It ensures that after you click away, the reference line stays where you set it. If you chose "Set value to," the line would disappear or reset every time you deselected.
  8. Click OK twice to close both dialog boxes.

Step 5: Test Your Interactive Dashboard!

Now for the fun part. Click on any point along your line chart. You should see the reference line instantly jump to the sales value of the month you selected. Click another data point, and the line will move again. You've successfully built a dynamic, user-driven dashboard feature that provides context and encourages exploration.

Advanced Tips and Further Ideas

Once you've mastered the basics, you can apply the same concept for much more complex interactions.

Passing Dimensions to a Parameter

Your action doesn't have to be limited to measures like sales. You can pass a dimension value (like a Category name or a Region) to a string-based parameter. This enables dynamic text annotations, conditional highlighting based on the selected dimension, or even building URLs that change based on what a user clicks.

To do this, simply create a parameter with a String data type and choose the appropriate dimension as the Source Field in your parameter action setup.

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.

Sheet Swapping Controls

Create a few small "button" worksheets containing only text. For example, one sheet could be a calculated field with the string "View Sales Trend," and another could say "View Profit Trend." Then, create a parameter action that updates a string parameter ("Selected View") when a user clicks on either of these button sheets. On your dashboard, you can use calculations based on this parameter to determine which of your main charts to show or hide, effectively "swapping" views for the user.

Final Thoughts

Parameter actions are a fundamental skill for moving from static reporting to building useful analytical tools in Tableau. They empower your audience to ask and answer their own questions, making your data more accessible, insightful, and engaging for everyone involved. While mastering the intricacies takes practice, the fundamental steps are straightforward and open up a new level of custom dashboard design.

Building this level of interactivity is incredible, but it often takes focus and a willingness to learn the detailed mechanics of BI tools. For many B2B teams who need to move faster, the answer isn't always to become part-time visualization specialists, so we created Graphed to simplify the process of connecting to your critical platforms and finding business insights you're seeking. Our platform lets you connect data sources like Shopify, Google Analytics, and Facebook ads, then use natural language to instantly build real-time dashboards and get immediate answers to your analytics questions. After all, the goal is in the insights, not becoming an expert with the tool.

Related Articles