Forum Discussion

nrahn's avatar
nrahn
New Member
9 years ago
Solved

Line and column chart, Line one two axis

 

I have created a Line and clustered column chart and i have the columns and lines working correctly except for the measure for the columns i want to change from a column to a line. The measure field is a total average of the %var. I want this to be a line but stay on the column axis. please note that the mar% is on a different axis than measure and %var

 

  • It appears there is currently no way to do this in PowerBI

8 Replies

  • Hi nrahn,

     

    Taking into account that both your axis are in percentage if in the Y-Axis options you turn off the secondary axys the visual will be reformated to only use one axis for both columns and lines.

     

    Regards,

     

    MFelix

    • nrahn's avatar
      nrahn
      New Member

      You are correct but this will not work for my solution as the data realistically could be as separate as they are. Columns and total avg in the -% while the margin above +50%. turning off the secondary changes the chart to look like the below.

       

      • MFelix's avatar
        MFelix
        Super User

        Did you try use the star and end to reset the size of you two Y-axis

  • It appears there is currently no way to do this in PowerBI