Why can't you synchronise your dual axis?

by Stephanie Kearns

Have you ever built a chart in Tableau with two measures and then not been able to synchronise your dual axis?

Why does this happen and what are your options to get around it?


sync axis unavailable



Why does this happen?


Tableau doesn’t allow you to synchronise your dual axis if the measures are different data types. For example, in the image above, one of the measures is an integer and one is a decimal. To be able to sync the axis, they need to be the same data type.



How do you get around this?


There are two options to get Tableau to allow you to put these two measures on the same scale:


Change one of the measure data types. In the example above, the right-hand measure was an integer, so we change this by adding 1.00 using an in-line calculation. This will change the measure to a decimal. You’ll now be able to synchronise your axis


change data type to sync axis



Or, create a chart using measure names and values, instead of dual axis. This will have the same effect as a synchronised, dual axis without having to change one of the data types.


measure names and values


Stephanie Kearns

Mon 29 Jan 2018

Fri 15 Dec 2017

Thu 14 Dec 2017