Tableau Course
Interactive Dashboards
An interactive dashboard lets the viewer drive the analysis — changing what they see without needing a developer to rebuild the view. Parameter controls, show/hide containers, set actions, and sheet swapping are the four techniques that turn a static dashboard into a self-service tool.
Parameter Controls on a Dashboard
Parameters were introduced in Lessons 33 and 34. On a dashboard, a parameter control is a widget — a slider, dropdown, or radio button list — that the viewer uses to change a parameter value. Because calculated fields and reference lines can both reference parameters, changing the parameter value instantly updates every chart that uses it.
To show a parameter control on a dashboard: right-click the parameter in the Data pane → Show Parameter. The control appears as a floating or tiled card. You can then drag it into position on the dashboard layout like any other object.
Show/Hide Containers
A show/hide container is a layout container with a toggle button attached to it. When the viewer clicks the button, the entire container — and everything inside it — collapses or expands. This is the cleanest way to add optional detail panels, filter drawers, and help text to a dashboard without permanently occupying canvas space.
Set Actions
A set action dynamically updates the members of a Set based on what the viewer selects on the dashboard. Sets are a Tableau concept that divides Dimension members into two groups — In and Out. When a set action fires, the selected marks are placed In the set and everything else moves Out. Any chart using that set as a filter or colour field updates immediately.
Set actions are created through Dashboard → Actions → Add Action → Change Set Values. You define the source sheet, the trigger, the target set, and what happens when the selection is cleared — the same structure as filter and highlight actions.
The most powerful application of set actions is the proportional brushing pattern — selecting a group of customers or products on one chart and seeing their contribution highlighted as a proportion on every other chart simultaneously.
Sheet Swapping
Sheet swapping shows different charts in the same canvas zone depending on what the viewer selects — for example, a toggle between a bar chart and a map, or between a monthly and a weekly view. It is implemented by stacking multiple sheets in the same floating container and using a parameter to control which one is visible.
Change Parameter Action
A Change Parameter action updates a parameter value when the viewer clicks a mark — without requiring a visible parameter control widget. This enables click-to-select driven interactivity where clicking a customer name populates a detail view filtered to that customer, or clicking a product updates a reference line threshold.
It is created through Dashboard → Actions → Add Action → Change Parameter. You choose the source sheet, the trigger, the target parameter, and which field's value to pass into the parameter when the mark is clicked.
Interactivity Techniques — When to Use Each
| Technique | Use When | Not Ideal When |
|---|---|---|
| Parameter Control | Viewer needs to dial in a value — Top N, threshold, date range, metric selector | The choices are Dimension members that change as data updates — use a filter instead |
| Show/Hide Container | Optional detail panels, filter drawers, or help text that most viewers will not need most of the time | Critical information — if viewers need it every time, keep it visible |
| Set Action | Comparing a selected group against the rest — proportional brushing, in-group vs out-group analysis | Simple filtering where a regular filter action is clearer and easier to build |
| Sheet Swapping | Letting the viewer choose between chart types or granularity levels in the same canvas zone | More than 3–4 swap options — the stacked sheets become hard to manage |
| Change Parameter Action | Click-to-select should drive a calculation or reference line rather than a filter | The viewer needs to filter data — use a filter action which is more direct |
Show/hide containers changed dashboard design by eliminating the trade-off between visible filters and available canvas space — content that is needed occasionally now lives off-canvas until called. The rule: if a viewer needs content every time they open the dashboard, keep it visible; if it is occasional, put it in a container. Set actions are the most underused beginner feature — a Set is just a named In/Out split of a dimension, and a set action lets the viewer control that split by clicking, which makes cross-chart highlighting feel natural and powerful.
Practice Questions
1. A dashboard has six filter cards taking up a large portion of the canvas. Most viewers only use the filters occasionally. How do you keep the dashboard clean while still making the filters accessible?
2. A viewer wants to click customer names on a bar chart and see those customers highlighted in orange on a scatter plot, while all other customers stay grey. Which interactivity technique achieves this?
3. A dashboard zone should show either a bar chart or a map depending on which view the viewer selects from a toggle. Describe the technique and its four key steps.
Quiz
1. A viewer selects two product categories on a bar chart and all charts on the dashboard should immediately show those categories highlighted against the rest. Which action type is designed for this in-group vs out-group pattern?
2. A parameter already exists in the workbook. How do you make its control widget visible to viewers on the dashboard?
3. A show/hide container holds a detail panel that should be collapsed when the dashboard first opens. How do you set the container to start in the hidden state by default?
Next up — Lesson 44: Story Points — building guided narratives in Tableau using the Story feature to walk viewers through a sequence of insights.