ad

Scenario 9 Some times we will see synchronize axis option as disabled. why? And how to solve this?

Scenario 9:
Problem: Some times we will see synchronize axis option as disabled. why? And how to solve this?

Description:

In this chart I am showing State wise Sales on one axis and on another axis I am showing countD of Order ID.







I am using Dual axis for this chart. When I am trying to Synchronize both axis, I am seeing 
Synchronize axis option as disabled. See below




Why I am Seeing Synchronize Axis Option Disabled?

Ans: When you are trying to Dual axis two different types of measures. I mean two different data types of measures then we will see Synchronize Axis option as disabled.

In this example I am using Sales and CountD(Order ID). Sales numbers have floating values. Where as CountD(Order ID) will give us Integer value.

For State New York:

Sum(Sales): $839,593.73 (Which is float number)
CountD(Order ID): 402 (Which is Integer)

So if you come across this kind of scenario you wont see Synchronize Axis Option.

How to solve this?

Solution:

Solution is very simple. You need to convert integer values into float.
Create a calculate field and use that field in report.

float(CountD(Order ID))


Create dual axis chart using Sales and New calculated field. Now you will see Synchronize Axis Option Enabled.