KNOWLEDGE BASE

Synchronizing Axes


Product(s): Tableau Desktop
Version(s): All
Last Modified Date: 19 Jun 2014

Article Note: This article is no longer actively maintained by Tableau. We continue to make it available because the information is still valuable, but some steps may vary due to product changes.



A dual axis allows you to compare multiple measures with different scales by layering independent axes on top of each other. When creating a dual axis, it is recommended that you align the axes with each other using the “Synchronize Axis” option to ensure you make a scaled and correct comparison. However, sometimes this option may not be available. This is because the data type of one of the axes is different from the other. To resolve this issue, you must change the data type of one of the axes. 



This article uses the Sample – Superstore Sales (Excel) example. In this example, the Profit measure is a float, and the Number of Records measure is an integer.

Step 1

Right-click the Data window and select Create Calculated Field.

Step 2

Create a calculated field that changes the data type of a measure like in the following example:
 
Float([Number of Records)]



Or

Int ([Profit])


 
Note: To verify the data type of the field, refer to the description in the yellow box.

Step 3

Replace the measure on the view with the appropriate calculation you created in step 2.

Step 4

Right-click the secondary axis, and then select Synchronize Axis.
Did this article resolve the issue?