Combo charts (bar + line) in Tableau - Dashboard Guide

Dashboard Mode - Combo charts (bar + line)

Dashboard Goal

Understand monthly sales performance and profit trends together to see how profit changes relate to sales volume.

Sample Data

Month	Sales	Profit
January	1000	200
February	1500	300
March	1200	250
April	1700	400
May	1600	350
June	1800	450

Dashboard Components

• KPI Card: Total Sales calculated as SUM([Sales]). Result: 8800
• KPI Card: Total Profit calculated as SUM([Profit]). Result: 1950
• Combo Chart: Monthly Sales and Profit with bars showing Sales and a line showing Profit over months January to June.
• Table: Detailed monthly data showing Month, Sales, and Profit.

Dashboard Layout

+----------------------+----------------------+
|      Total Sales      |      Total Profit     |
|       (KPI Card)      |       (KPI Card)      |
+----------------------+----------------------+
|                                              |
|          Combo Chart (Bar + Line)             |
|                                              |
+----------------------------------------------+
|               Monthly Data Table              |
+----------------------------------------------+

Interactivity

A filter for Month allows selecting one or more months. When applied, the KPI cards, combo chart, and data table update to show data only for the selected months.

Self Check

If you add a filter to show only March to May, which components update and what will the Total Sales KPI show?

Answer: All components update. The Total Sales KPI will show 1200 + 1700 + 1600 = 4500.

Key Result

Dashboard showing monthly sales and profit with combo chart and KPIs for total sales and profit.