Line Chart two Axiz

[Mathew101]

Hi All,

Can anyone point me in the right direction, how to you get a line chart with 2 axis.

I want to plot amounts by date, now sales and units.  Now I can do this with the Combo-Chart, however I don't want on as a bar and one as a line.  I want the option to have both as a line....

Am I missing something here, or is this a limitation of Power BI charts?

Regards,

Mathew

[Anonymous]

@Mathew101,

Do you want to have two Y-Axis in Line chart?


If so, it is not possible. There are some ideas about this issue, please vote them up.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/19171342-add-dual-axis-charts-lin...
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/12490791-add-secondary-axis

Regards,
Lydia

[Mathew101]

Hi Lydia,

Like this in Excel: -

Thank you for the links I've up voted and commented

[vishal17081990]

Hi @Mathew101

You can do it with putting your Year column in Legand field.

Attached is PBIX for your reference.

https://1drv.ms/u/s!AoKR2AuKbWtQg0shNXVAPdFUYb_o

Hope this helps...

Regards,

Vishal.

[Mathew101]

Thanks for the reply Vishal, but we want the full timeline on the X - Axis and month-Year values for Sales amount on the left Y-axis and units on the right Y-axis