Line charts in Tableau - Dashboard Guide

Dashboard Mode - Line charts

Dashboard Goal

Track monthly sales trends over one year to see how sales change month by month.

Sample Data

Month	Sales
Jan	1000
Feb	1200
Mar	900
Apr	1400
May	1300
Jun	1500
Jul	1600
Aug	1700
Sep	1650
Oct	1800
Nov	1750
Dec	1900

Dashboard Components

• KPI Card: Total Sales
  Formula: SUM([Sales])
  Result: 18,700
• Line Chart: Monthly Sales Trend
  X-axis: Month (Jan to Dec)
  Y-axis: Sales
  Marks: Line connecting monthly sales points
  Purpose: Shows how sales increase or decrease each month

Dashboard Layout

+----------------------+-----------------------+
|      Total Sales      |   Monthly Sales Trend  |
|      (KPI Card)       |      (Line Chart)      |
+----------------------+-----------------------+

Interactivity

A filter for Year can be added (if multiple years exist). Selecting a year updates both the Total Sales KPI and the Monthly Sales Trend line chart to show data only for that year.

Self Check

If you add a filter for Month = "Jun" to "Aug", which components update and what do they show?

• Total Sales KPI: Updates to show sum of sales for Jun, Jul, and Aug (1500 + 1600 + 1700 = 4800).
• Monthly Sales Trend Line Chart: Updates to show only points for Jun, Jul, and Aug, connected by a line.

Key Result

A dashboard showing total yearly sales and a line chart of monthly sales trends.