Forum Discussion
Line and stacked column chart - Y-axis
Sure.
1. this one below has only one Y-axis and the proportion is what I want.
2. This one below has 2 Y-axises and the image is misleading. You can see that in July the total costs is abut $3M vs. $800k revenue while the chart might deliver a quite different impression at first look.
Hope this makes sense,
Hui
hwan You can do 2 things...
1) Enter start and end values to match the primary axis
OR
2) Turn off the secondary axis
Thanks Sean! Didn't know there is an option to turn off the secondary axis.
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.
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.
