Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Issue with two axis on line chart

Hi all,

 

I want to use the line chart visual which has Axis, Legend, Value, Y2 and tooltips as an oportunity to be filled.

 

I would like to create the line chart the way that it shows me based on the filters a brand market share over time. this is easy as I just have to put it X= Times, Brand in Legend and Values which are my share. I also have a measure showing me the past year shares which also works perfectly fine. Is there a reason why power BI doesn't let me put in the past year shares in Y2? Is there something special about the visual that has to be considered? If I put Times, Brands,share and past years share in a table it works as it is suppose to.

 

Thanks for any tipp

 

  • Icey's avatar
    Icey
    6 years ago

    Hi Anonymous ,

     

    How about using Multiple Axes Chart - XViz? You can change the series type to line.

     

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

4 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable

      It seems that power BI cannot handle two axis when there is multiple line charts. It only works if each value only cretaes one line

       

      • Icey's avatar
        Icey
        Icon for Community Support rankCommunity Support

        Hi Anonymous ,

         

        How about using Multiple Axes Chart - XViz? You can change the series type to line.

         

         

        Best Regards,

        Icey

         

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • candresbq's avatar
    candresbq
    Frequent Visitor

    Hello.

    I created a line chart and it creates two axes for me, but I would like it to only take the axis on the left as a reference.

    How can I turn off the axis on the right and make the two lines based on a single axis.

    Thanks a lot.

    candresbq_1-1606735061996.png