Sync both Y axis in Line and Cluster combo chart with Date Hierachy

[Majad_Chowdhury]

Hi all,

Annoying that this isn't simpler in power bi.

I have a cluster and line combo visual. It contains the following values

Column axis = Distinct count of ID

Line Axis 1 = TargetM

Line Axis 2 = TargetS

Line Axis 3 = TargetP

Line Axis 4 = TargetSD

The column axis is the primary Y axis on the left hand side and all the line axis are on the right hand side on the "secondary y axis"

The column also has a Column Legend called Channel which creates multiple bars per month.

I need both axis to have the same scale and the visual to still be able to drill up and down between respective date groupings. The fact the x axis is a date hierachy probably complicates matters.

I basically need the max value of whatever is showing in the visual at the moment. So for example, here i would need 1340 :

Whereas here when i drill back out to Quarterly, I would need 2254:

Bare in mind, the max value could come from the lines or the column.

[MFelix]

Hi @Majad_Chowdhury ,

On this type of visualization you need to have both lines and bars to have a single axis, just turn off the secondary Y-Axis values and you will get a single axis for both categories then dependending on each one is higer you will get the axis aligned.

[Majad_Chowdhury]

I have this turned off however it is still there.

I think maybe because its a combo chart with Clustered Column with a legend (so multiple columns per month) and a line chart, it automatically adds the secondary axis. 

Seems crazy that i cant turn it off

i think the solution might be to create a measure which gives the highest value currently on display in the visual and use this as the max axis for both primary and secondary axis.....but i have no idea how to do this.

[MFelix · Accepted solution]

Hi @Majad_Chowdhury ,

The fact that we have legends on the chart has no impact on the single axis values:

Has you can see from the images above there is only a single axis, Try the following on the Secondary Y-Axis turn on and then off again the values and see if you get a single axis.

[Majad_Chowdhury]

Thank you!

Rather incredibly, switching the values back on and off again removed the secondary axis! Very vizzre!