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

[paulinuk2017]

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

[v-ljerr-msft]

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. 

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