Clustered Column Chart with multiple Line Graphs that one of them have shared axis with the columns

[morteza]

Hi,
Does anyone know if it's possible to have multiple line charts on a "Clustered Column Chart" visual in Power BI so that one or more of the line graphs have a shared axis and scale with the bar chart/columns while at least one of the lines is on the secondary axis which has a different scale than the column chart? For more clarifications, I basically would need the following two report pages to be merged as a single one:

[morteza]

 Thanks @Anonymous ! I wish microsoft would add this feature to the "Line & Clustered Column Chart" visual so enabling users to switch the line chart between either of the two Y-axes. For now any line graph added can only be displayed on the secondary Y-axis.

[Anonymous]

Hi @morteza ,

As far as I know, all lines will be displayed with the right Y-axis as the reference in Line and clustered column chart.

Although you can add both the line with density in millions on the left and the line with density in decimals on the right to Line field, Power BI will create the Y-axis of the line by the largest magnitude(Million). So the percentage lines will tend to be close to 0. 

I think it is not a good idea to combine two visuals as one.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.