KNOWLEDGE BASE

How to Synchronize Axes Across Sheets


Published: 05 Oct 2021
Last Modified Date: 08 Oct 2021

Question

How to sync the axes of multiple sheets on a dashboard with the same scale?

Environment

  • Tableau Desktop

Answer

The following steps are demonstrated in the attached workbook using the Sample -Superstore data source.
  1. Create a parameter named Max of Axis with the following settings.
  • Data type: Integer
  • Current Value: enter the preferable maximum value of axes.
  • Allowable values: All
  1. Click Analysis > Create Calculated Field to create the Reference Line calculated field including the following formula.
    MAX([Max of Axis])
    
  2. Place Profit to columns, Segment to rows, and Reference Line to details.
  3. Right-click the axis > Add Reference Line with the following settings.
  • Scope: Per Pane
  • Value: AGG(Reference Line), Maximum
  • Labe: None
  • Tooltip: None
  • Line: None
  1. Right-click the Max of Axis parameter > Show Parameter.
  2. Open a new sheet and place Sales to columns, Ship Mode to rows, and Reference Line to details.
  3. Right-click the axis > Add Reference Line with the same settings of step 4.
  4. Open a new dashboard and place Sheet 1 and Sheet 2.
Did this article resolve the issue?