0 votes
1 view
in BI by (15.1k points)

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.

enter image description here

Now what I want to have the two FY13 bar charts to be line charts superimposed on their corresponding FY14 bar charts.

1 Answer

0 votes
by (41.2k points)

Yes, this is possible.

  1. Drop the measure in the row shelf.
  2. Then grab the same measure with Control key pressed and drop it again on the row shelf.
  3. You will have two instance of the same measure on the row shelf.
  4. Right Click the second measure on the row shelf and click dual axis.
  5. Right click the axis on the worksheet and Edit axis to your choice.

Create 2 calculated feild:

  1. If [FY] = "FY13" then [Value] end

call it- 2013 and

  1. If [FY] = "FY14" then [Value] end

call it- 2014

Then just do as i have done in this image.

enter image description here

Related questions

Welcome to Intellipaat Community. Get your technical queries answered by top developers !