Forum Discussion

morteza's avatar
morteza
Helper I
3 years ago

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

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:

 



Need Help
Tips and Tricks

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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.

  • morteza's avatar
    morteza
    Helper I
    3 years ago

     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.