Forum Discussion

hwan's avatar
hwan
Frequent Visitor
10 years ago
Solved

Line and stacked column chart - Y-axis

Hello,   I am trying to do a line and stacked column chart to compare revenue and cost. My axis is month. I am thinking to use the line for revenue, stacked column for costA and costB(costA+costB =...
  • Sean's avatar
    Sean
    10 years ago

    hwan You can do 2 things...

     

    1) Enter start and end values to match the primary axis

    OR

    2) Turn off the secondary axis

     

     

marcusmaximus's avatar
marcusmaximus
Regular Visitor
4 years ago

I'll be honest, I don't think either of these solutions really resolves it. If you don't show the secondary y axis, the line will appear at the wrong level. If you fix the axis to specific ranges then they are not scalable for when you apply filters etc.

 

In Tableau you are able to 'synchornize axis', which is the right solution. I don't think this is available in Power BI it seems.

PatrikSwe's avatar
PatrikSwe
Regular Visitor
3 years ago

I experienced the same thing; that my secondary y-axis was still there (invisible) when I turned off the secondary axis and that the line wasn't aligned with the primary y-axis. But in my case it was because I hade set a start value (0) for my secondary axis before turning it off, as opposed to keeping it as Auto. Once I went back to Auto for the start value of the secondary axis it dropped the "invisible" axis and aligned with the primary one.