I'm aware of how to create a dual-axis chart using two different measures for the Y-axis.
What I want?
Create a dual-axis chart using the same measure but on two different range in the dual-axis?
For example, I have a revenue column and, I want to create a dual-axis chart where one axis has revenue for the Year 2013, and the other with revenue for the Year 2014.
I want to create a line chart for the revenue Year 2013, and bar chart for the revenue Year 2014, on the same chart. See picture below is what I have done to have FY13 and FY14 values for each month and running monthly cumulative.
Now what I want to have the two FY13 bar charts to be line charts superimposed on their corresponding FY14 bar charts.