Skip to content
Tutorials Center
My learning

Topics

Lesson 19 of 35 ยท Dashboards

Tableau Dashboard Actions, Interactivity and Stories

Make Tableau dashboards interactive: use as filter, filter, highlight, URL, go to sheet and parameter actions, viz in tooltips, and build stories with story points and captions.

A static dashboard shows numbers; an interactive one lets a reader ask the next question. Click a bar and the other charts follow, hover a mark and see detail, jump to a sheet or a web page. These behaviors are dashboard actions. A story then arranges views in a guided sequence, like slides with live data.

This lesson describes the Tableau steps and uses small Python stand-ins to show what an action does to the data: it turns your selection into a filter on other sheets.

Use as Filter: the quickest action

On a dashboard, select a worksheet and click the funnel icon (Use as Filter) in the top right of its frame. Now clicking a mark (a bar, a map region, a legend entry) filters every other sheet in the dashboard that shares the filtered field's data source and field. Click the same mark again, or an empty area, to clear the filter.

Use as Filter is a shortcut for a filter action with default settings. For full control, use the Dashboard > Actions... dialog.

The Actions dialog

Choose Dashboard > Actions... (or Worksheet > Actions...) and click Add Action. Tableau offers six types.

Action What it does
Filter Selecting marks in a source sheet filters target sheets
Highlight Selecting marks highlights related marks in other sheets without removing anything
Go to URL Opens a web page; the URL can include field values (https://example.com/search?q=<Customer>)
Go to Sheet Jumps to another sheet, dashboard or story
Change Parameter Writes the selected value into a parameter
Change Set Values Writes the selected marks into a set

Settings that apply to most actions:

  • Source Sheets: where the user interacts (a dashboard and its sheets).
  • Run action on: Hover, Select or Menu. Hover feels immediate, but is hard on touch devices; Select is the best default; Menu adds the action to the tooltip.
  • Target Sheets and Target Filters: All Fields (matches every shared field), Selected Fields (only chosen ones) or a field mapping when names differ.
  • Clearing the selection will: Leave the filter, Show all values or Exclude all values. Show all values is the friendliest default.

Try it: a filter action as a query (stand-in)

Selecting the West bar adds the condition region = 'West' to the other sheets' queries. This Python stand-in applies the same selection to two "sheets".

Python Stand-in: a selection filters the other sheets

Press Run (or Ctrl + Enter) to see the result here.

Program input ยท what you'd type while the program runs

Type the answers before you press Run, one per line. Each time the program reads a line (with input()), it gets the next line from this box.

The source sheet keeps all its bars so you can click another one; the target sheet shows only West. That is why a filter action usually sets source = the overview chart and target = the detail charts.

Highlight action and the Highlighter

A Highlight action dims everything except related marks, so context is not lost. A quick alternative: right-click a legend or a dimension header > Highlight Selected Items or use Analysis > Highlight and add a Highlighter control: users type text to highlight matches in the view (handy for long lists).

Go to URL and Go to Sheet

A Go to URL action can include fields (<Customer ID>), so each mark opens its own page: a CRM record, a search, an order tracker. Open it in the browser or in a web page object on the dashboard. A Go to Sheet action is a drill-through: click a region and jump to a detailed dashboard. Add a Navigation object (a button) for a clear "Back to overview" link.

Parameter and set actions

A Change Parameter action stores the selected mark's value in a parameter, so a calculation can react: select a country and a text object shows its target, or a reference line moves to the clicked value. A Change Set Values action adds the selected marks to a set, which enables features such as "compare the selected members against all others" (use the set In/Out on Color).

Viz in Tooltip

A tooltip can contain another worksheet. Edit a mark's tooltip (Marks card > Tooltip) > Insert > Sheets and pick a small sheet. When viewers hover a bar, they see a mini chart for that mark. The embedded sheet is filtered by the hovered mark's dimensions, so it shows history or composition without using dashboard space.

Keep the tooltip sheet small (about 300 x 200), and avoid very slow queries: it runs on every hover.

Sheet swapping with containers

A trick for showing different charts in the same place: put several sheets in a container, and show only one by toggling a Boolean-driven filter or using a Change Parameter action that decides which sheet has data. The visible sheet reacts to a parameter-driven calculated filter and the others become empty and collapse. Modern Tableau versions also offer dynamic zone visibility (Show/hide based on a field), which makes this simpler.

Building a story

A story is a sequence of story points, each showing a worksheet or dashboard with a caption. It is meant for presentations and for explaining a finding to someone who will not explore alone.

  1. Click the New Story icon at the bottom, or Story > New Story.
  2. Choose a size in the left Story pane.
  3. Drag a sheet or dashboard onto the canvas. Add a caption (the text above it) that states the point.
  4. Click New Blank Point to add the next point or Duplicate to copy the current one and then change it (a filter, a highlight, an annotation).
  5. Reorder points by dragging the navigator boxes at the top; rename them to meaningful labels.
  6. Use Add a caption and a Text object for commentary. Use Update (the button under the story point) after you change the underlying sheet so that the point shows the updated state.

Each story point remembers its state: filters, selected marks and annotations. That is the strength of a story, because you can make five different points with one dashboard (clicking a different mark in each).

flowchart LR
    S1["1. Overview<br/>sales are up 12%"] --> S2["2. Drill in<br/>growth is in the West"]
    S2 --> S3["3. Problem<br/>Furniture loses money"]
    S3 --> S4["4. Action<br/>cut discounts above 20%"]

A story follows a narrative: context, evidence, problem, recommendation.

Try it: story points as saved states (stand-in)

Python Stand-in: each story point stores filters and a caption

Press Run (or Ctrl + Enter) to see the result here.

Program input ยท what you'd type while the program runs

Type the answers before you press Run, one per line. Each time the program reads a line (with input()), it gets the next line from this box.

The same data, three states, three messages. In Tableau you get the same effect by selecting marks or setting filters in each story point.

Story design tips

  • One message per point, written as a sentence in the caption.
  • Keep to five to seven points; a longer story belongs in a dashboard.
  • Use annotations (right-click a mark > Annotate) and highlights to point the eye.
  • End with a recommendation, not just a chart.
  • Check the story in Presentation Mode (F7) and in the published view.

Common mistakes

  • Hover actions on touch devices: they do not work well. Use Select.
  • Filter actions across sheets with different data sources, which do not match by default (define a field mapping).
  • Clearing the selection "Excludes all values", so users see empty charts after a second click.
  • Stories that are just a gallery of charts without captions or an argument.

Check your understanding

Quick check ยท 5 questions

of 5 answered You scored / 5 ยท perfect!

  1. 1. Which action keeps all marks visible but dims the unrelated ones?

    A highlight action emphasizes related marks without removing others, so context stays visible.
  2. 2. What does the Use as Filter button on a dashboard sheet do?

    It is a shortcut filter action: selecting marks in that sheet filters the others.
  3. 3. Which clear-selection behavior is usually friendliest?

    Show all values resets the targets to the full data when the selection is cleared.
  4. 4. What is a story point?

    Each story point stores a view, its filter state, annotations and a caption.
  5. 5. Viz in Tooltip places what inside a tooltip?

    An embedded worksheet appears when the viewer hovers over a mark, giving context without using page space.

Summary

  • Use as Filter is the quick way to make sheets drive each other; the Actions dialog gives full control (Filter, Highlight, URL, Go to Sheet, Change Parameter, Change Set Values).
  • Source sheets are what the user clicks; target sheets are what changes; choose Select over Hover for touch.
  • Viz in Tooltip and sheet swapping add detail without using space.
  • A story is a sequence of story points with captions; each remembers its filters, selection and annotations.

Next: Back to the Tableau course