Forum Discussion

paulinuk2017's avatar
paulinuk2017
Frequent Visitor
8 years ago

Line & Clustured Column Chart using 3 Line values with different Y-Axis

Hello

 

My user wants to have a line chart with 3 lines 

 

Series 1 needs to plot on the left Y axis and Series 2 and 3 need to plot on the secondary axis

 

I can only see a way of doing a bar and then lines for the other

 

Why does this basic functionality exist?  Does anyone know a workaround?

 

Its really frustrating that such a basic requirement doesnt seem to exist!

 

Paul

Need Help

1 Reply

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Microsoft Employee
    8 years ago

    Hi paulinuk2017,

     

    Currently, it doesn't support to add a secondary axis on the Line chart. Here is the idea shared on Power BI Ideas forum. You can vote it up and add your comments there to improve Power BI on this feature. :smileyhappy:

     

    In addition, an alternative solution could be creating R visual by yourself, you can take a look at the following link to get details.

    https://plot.ly/r/multiple-axes/ 

     

    Regards