Line charts

[Richard76]

Hi Folks,

is it possible to plot 2 lines on a line graph in power BI but against different axis . So I want to place price per unit (small value) against quantity sold (big value) so want to be able to use different scales. Also, I have a table showing products down the left hand side and sales per month along the top. When I try to convert this to a simple line graph it moves the products to the x axis and the months to the y - I cant see an easy way to swap these around..

Any help much appreciated.

Rgds

Richard

[v-piga-msft]

Hi  @Richard76,

It seems that you want to a line chart with two lines and add a secondary axis which is not supported in Power BI currently.

You could vote this similar idea here and add your comments there to improve Power BI and make this feature coming sooner.

For the workaround, you could use  Line and Stacked column chart which has two axis.

Best Regards,

Cherry

[Richard76]

Thanks Cherry - is there an easy way to swap the axis so the months are along the bottom ??