I'm aware of how to create a dual-axis chart using two different measures for the Y-axis. Is there a way for me to create a dual-axis chart using the same measure but on two different ranges in the dual-axis? For example, I have a column which contains revenue, 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.
my aim is to create a line chart for revenue Year 2013, and bar chart for 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 wanted to do is to have the two FY13 bar charts to be line charts superimposed on their corresponding FY14 bar charts.
I attach also my Tableau workbook that creates the charts above in the first tab.