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

Avatar

Stephanie Kearns

Data School Reflections

2 mins read

Mon 29 Jan 2018

Star Wars - Dashboard Week Day Five

1 mins read

Fri 15 Dec 2017

Cheese - Dashboard Week Day Four

1 mins read

Thu 14 Dec 2017

Looks vs Personality - Dashboard Week Day Two

2 mins read

Wed 13 Dec 2017