Adding sheets to dashboard in Tableau - Dashboard Guide

Dashboard Mode - Adding sheets to dashboard

Dashboard Goal

See sales performance by region and product category all in one place to quickly spot trends and compare results.

Sample Data

Region	Product Category	Sales	Profit
East	Furniture	1000	200
East	Technology	1500	300
West	Furniture	1200	250
West	Office Supplies	800	100
Central	Technology	1300	270
Central	Office Supplies	900	150

Dashboard Components

• Sheet 1: Sales by Region Bar Chart
  Shows total sales for each region.
  Calculation: SUM([Sales]) grouped by [Region].
• Sheet 2: Profit by Product Category Pie Chart
  Shows profit distribution by product category.
  Calculation: SUM([Profit]) grouped by [Product Category].
• Sheet 3: Detailed Data Table
  Shows all data rows with Region, Product Category, Sales, and Profit.
  No calculation, just raw data.

Dashboard Layout

+---------------------------+---------------------------+
| Sales by Region (Bar)     | Profit by Product (Pie)   |
|                           |                           |
+---------------------------+---------------------------+
|          Detailed Data Table (Full Width)             |
+-------------------------------------------------------+

Interactivity

Adding a filter for Region on the dashboard will update:

• Sales by Region Bar Chart (shows only selected regions)
• Profit by Product Category Pie Chart (calculates profit only for selected regions)
• Detailed Data Table (shows only rows for selected regions)

This filter connects all sheets so you can explore data by region easily.

Self Check

If you add a filter for Product Category = Technology, which components update and what changes?

• Sales by Region Bar Chart updates to show sales only for Technology products by region.
• Profit by Product Category Pie Chart updates to show profit only for Technology category (so it will show one slice).
• Detailed Data Table filters to show only rows where Product Category is Technology.

Key Result

A Tableau dashboard combining sales by region, profit by product category, and detailed data table with interactive region filter.