Problem:
When creating chart with Dual Axis, Synchronize Axis is disabled and cannot be clicked.
Cause:
Tableau identified this as a bug, though it is supposed to have been fixed on later version, but it somehow still happens.
Solution:
1. To enable Synchronize Axis, make sure that the data type of both the measures are the same.
2. If you are using Integer data type, problem persists even if the data types are the same. You should convert the measures to float.
Notice that now the Synchronize Axis is enabled after we convert the data type to float.
Format it with 0 decimal points if you want it to appear as integer.
And this is how the end result looks like.
PS: I know the graph is ugly, but I hope you get what you need :)
When creating chart with Dual Axis, Synchronize Axis is disabled and cannot be clicked.
Cause:
Tableau identified this as a bug, though it is supposed to have been fixed on later version, but it somehow still happens.
Solution:
1. To enable Synchronize Axis, make sure that the data type of both the measures are the same.
2. If you are using Integer data type, problem persists even if the data types are the same. You should convert the measures to float.
Notice that now the Synchronize Axis is enabled after we convert the data type to float.
And this is how the end result looks like.
PS: I know the graph is ugly, but I hope you get what you need :)
