Line Chart two Axiz

Question

Hi All,&nbsp;Can anyone point me in the right direction, how to you get a line chart with 2 axis.&nbsp;I want to plot amounts by date, now sales and units.&nbsp; Now I can do this with the Combo-Chart, however I don't want on as a bar and one as a line.&nbsp; I want the option to have both as a line....&nbsp;Am I missing something here, or is this a limitation of Power BI charts?&nbsp;Regards,Mathew

anonymous · Answer

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-line-and-line-charthttps://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/12490791-add-secondary-axisRegards,Lydia

vishal17081990 · Answer

Hi&nbsp;@Mathew101&nbsp;You can do it with putting your Year column in Legand field.Attached is PBIX for your reference.&nbsp;https://1drv.ms/u/s!AoKR2AuKbWtQg0shNXVAPdFUYb_o&nbsp;&nbsp;Hope this helps...&nbsp;Regards,Vishal.

mathew101 · Answer

Hi Lydia,&nbsp;Like this in Excel: -&nbsp;Thank you for the links I've up voted and commented

mathew101 · Answer

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

Forum Discussion

Line Chart two Axiz

4 Replies

Related content

Line chart

Time Line Chart

Previous Year Measure for Line Chart

Forecast in Line Chart

Line chart broken