Dashboards in Tableau

A Tableau dashboard is a canvas where multiple worksheets, text boxes, images, and other objects live together to tell a data story. Unlike a standalone worksheet, a dashboard is about synthesis — bringing related views into a single screen so that a viewer can understand the whole picture at a glance and then drill into specific details through interactivity.

This chapter covers everything from the dashboard workspace and sizing options, to layout containers, objects, and the full suite of dashboard actions that make your dashboards genuinely interactive.

---

Dashboard vs. Worksheet vs. Story

Before diving in, it is worth clarifying how these three Tableau constructs relate to each other:

Concept	Purpose	Contains
Worksheet	Single analytical view (chart, map, table)	Data fields, marks, axes
Dashboard	Composed analytical screen	Worksheets + objects + actions
Story	Guided narrative sequence	Dashboards and/or worksheets as story points

Worksheets are the building blocks. Dashboards assemble those blocks into a screen. Stories arrange dashboards and worksheets into a sequential, presentation-style narrative.

You cannot place a story inside a dashboard, but you can place any worksheet or dashboard inside a story.

---

The Dashboard Workspace

When you click the "New Dashboard" button at the bottom of the Tableau Desktop window (the icon that looks like a grid), the workspace changes significantly from the worksheet view.

Left Sidebar: Three Panels

Sheets Panel Lists every worksheet in the workbook. You drag sheets from here onto the dashboard canvas to add them as views. Sheets already on the dashboard are shown with a small checkmark icon.

Objects Panel Lists the non-data objects you can add to a dashboard:

• Text
• Image
• Web Page
• Blank
• Navigation
• Extension
• Download
• Ask Data (if enabled)

Layout Panel Appears when you click an existing object on the canvas. Shows the selected object's position (X, Y coordinates), size (W, H in pixels), padding (inner and outer), background color, and border settings. This panel gives you pixel-precise control over positioning.

Device Preview

The Device Preview bar at the top of the workspace lets you switch between viewing your dashboard as it would appear on:

• Default — the layout you design for all devices
• Desktop — a specific desktop size
• Tablet — typically 1024 × 768 landscape
• Phone — typically 375 × 812 portrait

When you add a device-specific layout, Tableau copies the Default layout as a starting point, and you can then rearrange or hide elements specifically for that device.

The Canvas

The canvas is the white area in the center where you build your dashboard. You drop worksheets and objects onto the canvas. When you hover over the canvas while dragging, blue shading appears to indicate where the object will land.

Size Panel

At the top of the left sidebar (when the Dashboard tab is active) is a Size dropdown. This is one of the most important settings — it determines whether your dashboard has a fixed pixel dimension or adapts to the browser window.

---

Dashboard Sizing

Fixed Size

You specify exact width and height in pixels. The dashboard will always render at those dimensions regardless of the viewer's screen size.

When to use: When you are publishing to a known environment (e.g., a specific monitor size in a meeting room, or a TV dashboard you control). Fixed sizes give you the most precise control over layout.

Common fixed sizes:

• 1366 × 768 (common laptop display)
• 1920 × 1080 (Full HD display)
• 1280 × 800 (older monitors)

Automatic

Tableau scales the dashboard to fit whatever container it is displayed in. If embedded in a web page, it fills the iframe. If opened in Tableau Server, it fills the browser window.

When to use: When you cannot predict the viewer's screen size and you want the dashboard to always fill available space. Works best when your layout uses proportional sizing rather than pixel-precise placement.

Range

You specify a minimum and maximum width (and optionally height). Tableau renders at the viewer's screen size as long as it falls within the range. If the screen is smaller than the minimum, scrollbars appear. If it is larger than the maximum, the dashboard centers with empty space around it.

When to use: When you need some flexibility but want to prevent the dashboard from becoming too compressed on small screens or too spread out on very large ones.

Device-Specific Layouts

In addition to the overall size setting, you can create separate layouts for Desktop, Tablet, and Phone:

1. In the Device Preview bar, select the device type
2. Click "Add [Device] Layout"
3. Rearrange, resize, or hide sheets and objects specifically for that device

This allows a desktop dashboard with 4 charts side-by-side to reformat into a phone dashboard with charts stacked vertically.

Best practice: Design the Desktop layout first, then adapt. On phone layouts, consider hiding complex visualizations and keeping only KPI cards and one primary chart.

---

Layout Containers

Layout containers are invisible structural elements that control how worksheets and objects are arranged relative to each other. They are the foundation of any maintainable dashboard layout.

Horizontal Container

Groups objects side by side in a row. When you add or remove items from a horizontal container, remaining items expand or contract to fill the available width.

To add a horizontal container:

1. Drag "Horizontal" from the Objects panel onto the canvas
2. Drop worksheets inside it

Vertical Container

Groups objects stacked top to bottom. Items grow or shrink vertically as you add or remove content.

Tiled vs. Floating

Every object on a dashboard is either Tiled or Floating:

Mode	Behavior	Best For
Tiled	Snaps into the grid of containers; auto-sizes with the layout	Most worksheets and objects
Floating	Sits at an absolute X, Y position; ignores containers	Overlays, logos, decorative elements

To toggle an object between Tiled and Floating, hold the Shift key while dragging (to switch to Floating) or use the object's context menu.

Nesting Containers for Complex Layouts

Real-world dashboards often require complex layouts: a header row at the top, a row of KPI cards below it, then a large main chart, then two smaller charts side by side at the bottom. Achieve this by nesting containers:

Example layout structure:

Vertical Container (full dashboard)
├── Horizontal Container (header row)
│   ├── Text Box (title)
│   └── Image (logo)
├── Horizontal Container (KPI row)
│   ├── Text Box (KPI 1)
│   ├── Text Box (KPI 2)
│   └── Text Box (KPI 3)
├── Sheet: Main Bar Chart
└── Horizontal Container (bottom row)
    ├── Sheet: Line Chart
    └── Sheet: Map

When you resize the dashboard or change its fixed size, nested containers ensure all elements resize proportionally and maintain their relative positions.

Tips for Working with Containers

• To select a container without selecting its contents, click the gray border around it or use the breadcrumb at the bottom of the canvas that shows the hierarchy ("Dashboard > Vertical Container > Horizontal Container > Sheet").
• Use the Layout panel on the left to set explicit padding around containers (Inner Padding and Outer Padding). This creates consistent spacing between elements.
• To distribute items evenly inside a container, right-click the container → Distribute Contents Evenly.

---

Dashboard Objects

Beyond worksheets, you can add several types of objects to a dashboard:

Text Box

Use text boxes for:

• Dashboard titles
• Section headings
• Instructions or caveats for the end user
• Footnotes (data source, last updated date)

You can apply rich text formatting: bold, italic, font size, color, alignment, and hyperlinks. To insert a dynamic value like the current date, use a worksheet with a calculated field instead of a text box.

Image

Add your company logo, a decorative header image, or icons. Tableau accepts PNG, JPEG, and GIF formats. You can set the image to fit inside the container, fill the container, or display at its original size.

Tip: For logos, use PNG with a transparent background so the image blends with your dashboard background color.

Web Page

Embeds a URL in an iFrame directly on the dashboard canvas. Useful for:

• Embedding a live web-based KPI feed
• Showing documentation or methodology notes
• Displaying a static map image from an external service

Security note: Many websites block embedding via iFrame using X-Frame-Options headers. If a site does not display, it has blocked embedding.

Blank

An empty container used purely for spacing. When you need to add visual breathing room between elements but a container's padding is not enough, a Blank object gives you precise control over the gap size.

Navigation Button

Creates a clickable button that navigates to another sheet, dashboard, or story in the workbook. You can customize:

• Button text or an image
• Tooltip text on hover
• The destination sheet

This is how you build multi-dashboard workbooks with a navigation bar — a row of Navigation buttons at the top of each dashboard that link to each other.

Extension

Tableau extensions are third-party JavaScript applications that embed inside a dashboard object. They are downloaded from the Tableau Extension Gallery and offer capabilities not built into Tableau, such as:

• Write-back (let users enter data into a dashboard)
• Advanced custom charts (bullet charts, waterfall charts)
• Integration with external APIs

---

Dashboard Actions

Dashboard Actions are the mechanism that makes Tableau dashboards interactive. An action is a trigger (something the user does) that causes an effect (something changes in the dashboard or browser).

The Five Action Types

1. Filter Action

The most commonly used action. When the user interacts with a mark in the source sheet, it filters one or more target sheets.

Configuration:

• Source Sheets: which sheet triggers the action (e.g., a map)
• Run action on: Hover, Select, or Menu
• Target Sheets: which sheets are affected
• Clearing the selection behavior

Hover: Updates the target on mouse-over. Great for showing tooltips or linked details without requiring a click.

Select: Updates the target when the user clicks. The most common mode.

Menu: Adds an option to the right-click context menu of a mark. The action only fires when the user explicitly chooses it.

---

2. Highlight Action

Highlights matching marks across sheets without filtering away unmatched marks. Non-highlighted marks become semi-transparent.

Use case: Click a segment in a pie chart to highlight the corresponding bars in a bar chart. The user can see both the selected segment and the context of all other segments simultaneously.

Configuration:

• Choose which fields are used for the highlight match (you can highlight by one field even if the mark was clicked in a view of another field)

---

3. URL Action

Opens a URL in the user's default browser (or in a Web Page object on the dashboard) when a mark is clicked.

Use case: Click a product row in a table to open that product's web page. Click a news category to open a filtered news feed.

Dynamic URLs: You can embed field values in the URL using the syntax <Field Name>. For example:

https://www.google.com/search?q=<Product Name>

When the user clicks a mark for "Staples Easy-staple Stapler," Tableau opens a Google search for that product name.

---

4. Go to Sheet Action

Navigates the user to a different sheet, dashboard, or story point in the workbook.

Use case: A user clicks a bar in a summary dashboard to jump to a detail dashboard that shows the drill-down data for that bar.

Note: This is often confused with Navigation buttons. Navigation buttons are always visible. Go to Sheet Actions are triggered by clicking a specific mark.

---

5. Parameter Action (Tableau 2019.2+)

Updates a parameter value based on what the user clicks. This unlocks extremely powerful dynamic behavior because parameters can drive calculated fields, reference lines, filters, and more.

Use case: Click a product on a scatter plot to update a parameter that controls a reference line showing that product's average profit margin.

Configuration:

• Source Field: the field in the clicked mark whose value is assigned to the parameter
• Target Parameter: the parameter to update
• Aggregation: how to aggregate if multiple marks are selected (Sum, Average, etc.)
• Clearing behavior: keep the current value or set to a default

---

6. Set Action

Adds or removes values from a Tableau Set based on user interaction. Sets are named groups of dimension members that can be referenced in calculations and filters.

Use case: The user selects several customers on a scatter plot; those customers are added to a "Selected Customers" set. A separate view then shows only those customers' order history.

---

Creating an Action

1. Go to Dashboard menu → Actions (or in a worksheet: Worksheet menu → Actions)
2. Click Add Action
3. Choose the action type
4. Configure source, trigger, target, and clearing behavior
5. Click OK

To test, switch to Presentation mode or preview in a browser.

---

Best Practices for Dashboard Design

Visual Hierarchy

Place the most important information at the top-left. Eye-tracking research consistently shows that viewers begin in the upper-left quadrant of a screen. Your headline KPIs and primary chart should live there. Supporting detail and drill-down views move to the right and below.

Use size to convey importance: the primary chart should occupy more canvas space than secondary charts.

Color and Whitespace

• Use color purposefully. Do not apply different colors to every dimension member unless the color encodes a specific meaning.
• Maintain a consistent palette of 2–4 colors throughout the dashboard. Use your brand's primary color for the most important measure and a neutral gray or blue for secondary measures.
• Whitespace (padding, blank objects) is not wasted space — it guides the eye and prevents cognitive overload.
• Avoid chartjunk: grid lines, heavy borders, and background fills that do not add analytical value.

Choosing the Right Chart Type

Goal	Recommended Chart
Compare values across categories	Horizontal bar chart
Show trends over time	Line chart
Show geographic distribution	Filled map or symbol map
Show part-to-whole	Treemap or pie (max 5 slices)
Show correlation	Scatter plot
Show distribution	Histogram or box plot
Show progress to a goal	Bullet chart or gauge
Show many KPIs at once	Text table with color encoding

Where to Put Filters

Filter cards placed on a dashboard apply to all sheets by default (when configured with "All using this data source" or "Selected Worksheets"). Position filters:

• At the top of the dashboard for date/time range selectors (users expect global time controls at the top)
• On the right sidebar for category/segment selectors
• Avoid placing filters inside chart containers — they compete visually with the data

Performance Optimization

1. Minimize the number of sheets on a single dashboard. Each sheet is a separate query. 4–6 sheets per dashboard is a reasonable maximum.
2. Use extracts instead of live connections for dashboards viewed by many users simultaneously.
3. Avoid "Only Relevant Values" in filter cards — it fires additional queries every time a filter changes.
4. Hide unused fields from the data source to reduce memory usage.
5. Consolidate filters — one date filter that applies to all sheets is better than six date filters, one per sheet.

Accessibility

• Add descriptive titles to every worksheet and dashboard.
• Use tooltip text to explain what each mark represents.
• Avoid relying solely on color to encode data — use shape or size as secondary encodings for users with color vision deficiencies.
• Ensure sufficient contrast between text and background (WCAG recommends a 4.5:1 ratio for normal text).

---

Adding KPI Cards

A KPI card is a simple but powerful element: a large number (the metric) with a label and often a color indicator.

Method 1: Text Worksheet as KPI Card

1. Create a new worksheet
2. Drag a measure to the Text mark
3. Set the aggregation (e.g., SUM for total sales)
4. Format the number (currency, commas)
5. Drag a second calculated field to Color (e.g., a boolean: SUM([Profit]) >= 0)
6. Set colors: green for true, red for false
7. Remove all grid lines and axes
8. Give the sheet a meaningful title

On the dashboard, size this sheet to be small (e.g., 150 × 80 pixels) and tile three or four of them in a horizontal container across the top of the dashboard.

Method 2: Floating Text + Worksheet

Use a floating text box for the label and a floating worksheet for the number. This gives finer typographic control.

---

Creating a Navigation Bar Between Dashboards

For workbooks with multiple dashboards, a persistent navigation bar helps users move between views:

1. On each dashboard, add a Horizontal Container at the very top
2. Inside it, add one Navigation button per dashboard
3. Configure each button's destination, text, and style
4. Copy and paste this container to every other dashboard

For consistency, use the same container dimensions and button sizes on every dashboard. If you update the navigation (add a new dashboard tab), you only need to update each dashboard's navigation container.

---

Practice Exercises

Exercise 1: Building a Sales Overview Dashboard

Dataset: Sample - Superstore

Task:

1. Create three worksheets:
   • Sheet A: Horizontal bar chart of Sales by Category (sorted descending)
   • Sheet B: Line chart of Sales by Month of Order Date
   • Sheet C: Filled map of Sales by State
2. Create a new dashboard at Fixed size 1200 × 700 pixels.
3. Add a title text box at the top: "Sales Overview Dashboard."
4. Place Sheet C (map) on the left two-thirds of the canvas.
5. Place Sheet A (bar chart) on the upper right.
6. Place Sheet B (line chart) on the lower right.
7. Add a single Region filter card that applies to all three sheets.

Goal: Practice basic dashboard assembly and cross-sheet filter configuration.

---

Exercise 2: Interactive Drill-Down with Filter Actions

Dataset: Sample - Superstore

Task:

1. Create Sheet 1: bar chart of Sales by Category.
2. Create Sheet 2: bar chart of Sales by Sub-Category.
3. Create Sheet 3: table of Order ID, Product Name, Sales, Profit for individual orders.
4. Build a dashboard with all three sheets arranged vertically (Category at top, Sub-Category in middle, Orders at bottom).
5. Create a Filter Action: clicking a Category bar filters the Sub-Category view.
6. Create a second Filter Action: clicking a Sub-Category bar filters the Orders table.
7. Set clearing behavior to "Show all values" for both actions.
8. Test the drill-down: Category → Sub-Category → Individual Orders.

Goal: Build a multi-level interactive drill-down experience.

---

Exercise 3: Device-Responsive Dashboard

Dataset: Sample - Superstore

Task:

1. Build a Desktop dashboard (1280 × 800) with:
   • A header text box
   • Three KPI cards in a horizontal row (Total Sales, Total Profit, Number of Orders)
   • A bar chart and a line chart side by side below the KPIs
2. Add a Phone layout (375 × 812).
3. In the phone layout:
   • Stack all elements vertically
   • Keep only the three KPI cards and the bar chart
   • Hide the line chart (right-click the sheet on the phone layout → Hide)
4. Use Device Preview to verify both layouts look correct.

Goal: Understand device-specific layout design and element hiding.

---

Summary

In this chapter you learned:

• Dashboard vs. Worksheet vs. Story — worksheets are single views, dashboards compose multiple views, stories sequence them narratively.

• Dashboard Workspace — the left sidebar contains Sheets, Objects, and Layout panels; the canvas is where you build; the Device Preview lets you design for multiple screen sizes.

• Sizing Options — Fixed (exact pixels), Automatic (fills container), and Range (min-max flexibility). Device-specific layouts let you redesign for desktop, tablet, and phone independently.

• Layout Containers — Horizontal and Vertical containers control how objects are arranged and resize together. Tiled objects snap into containers; Floating objects sit at absolute positions. Nesting containers creates complex, maintainable layouts.

• Dashboard Objects — Text, Image, Web Page, Blank, Navigation, and Extension objects add context, branding, links, spacing, and advanced functionality beyond worksheet data.

• Dashboard Actions — the six action types (Filter, Highlight, URL, Go to Sheet, Parameter, Set) transform static dashboards into interactive analytical tools. Each action has a source, a trigger mode, a target, and a clearing behavior.

• Design Best Practices — hierarchy (important content top-left), purposeful color (2–4 colors), whitespace (breathing room), right chart for the right goal, filter placement, performance optimization (fewer sheets, extracts, no "Only Relevant Values"), and accessibility.

• KPI Cards — small worksheets or text objects that surface headline metrics prominently at the top of a dashboard.

• Navigation Bars — horizontal containers of Navigation buttons that create a consistent wayfinding experience across a multi-dashboard workbook.

Dashboards are the primary deliverable of most Tableau projects. Mastering their construction — technically and visually — is what separates a Tableau developer from a Tableau analyst.