Dashboard Mode - Synchronizing axes
Business Question
How can we compare monthly sales and profit trends side by side with synchronized axes to easily see their relationship?
0
0
Synchronizing axes in Tableau - Dashboard Guide
Sample Data
| Month | Sales | Profit |
|---|---|---|
| January | 10000 | 2500 |
| February | 12000 | 3000 |
| March | 15000 | 4000 |
| April | 13000 | 3500 |
| May | 16000 | 4500 |
| June | 17000 | 4800 |
Dashboard Components
- KPI Card - Total Sales: SUM([Sales]) = 83000
- KPI Card - Total Profit: SUM([Profit]) = 22300
- Line Chart - Monthly Sales and Profit: Dual-axis line chart with Month on X-axis, Sales on left Y-axis, Profit on right Y-axis. Axes synchronized to same scale (0 to 18000) for direct comparison.
- Table - Monthly Sales and Profit: Shows Month, Sales, and Profit side by side for reference.
Dashboard Layout
+----------------------+----------------------+ | KPI: Total Sales | KPI: Total Profit | +----------------------+----------------------+ | | | Line Chart: Monthly Sales & Profit | | (Synchronized Axes) | | | +----------------------------------------------+ | Table: Monthly Sales and Profit | +----------------------------------------------+
Interactivity
A filter for Month allows selecting one or multiple months. When applied, the KPI cards, line chart, and table update to show data only for the selected months. The synchronized axes on the line chart adjust dynamically to the filtered data range to maintain accurate comparison.
Self Check
If you add a filter to show only March to May, which components update and how?
- KPI Cards update to show total sales (15000 + 13000 + 16000 = 44000) and total profit (4000 + 3500 + 4500 = 12000) for those months.
- Line chart updates to show only March, April, and May data points with axes rescaled but still synchronized.
- Table updates to list only March, April, and May rows.
Key Result
Dashboard comparing monthly sales and profit with synchronized dual axes for clear trend analysis.