Forum Discussion

Richard76's avatar
Richard76
Helper II
8 years ago

Line charts

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

 

Show and Tell

2 Replies

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    8 years ago

    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's avatar
      Richard76
      Helper II
      8 years ago

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