Secondary y-axis toggle on/off button disappeared in Power BI Service

[ddunne1]

I have a line-and-stacked-column chart for which I need both y-axes to be synchronised. In my screenshot below, the line is represents a limit which the columns should not breach. The line is at 3 and the columns are 0.2, so the line should appear far above the columns indicating there is no risk of breach. I used to be able to achieve this by toggling on or off the Seconday y-axis, but that button seems to have disppeared from Power BI Service - see screenshot below. I don't have access to Power BI Desktop so my only option is to work with it in Power BI Service. Does anyone have any idea what I can do - has this toggle button moved elsewhere?

[Krishna_Mad]

I faced similar issue and it got resolved by aligning zeros for Y-axis and Secondary Y-axis and then updating Min and Max values to Auto for both the axis. Also please maintain size of text as 8.

Regards

Krishna Prasad Maddineni

[ksrini]

if we turn off values then axis itself goes off and line doesnt work. best is reduce font to 8.. color white - decimals 0.. then it wont be seen.

[ChrisCrocker]

This change is terrible. I have MANY existing reports with bar and line graph visuals that are all broken/inaccurate now because of this change. Please fix this Microsoft.

[ddunne1]

Hi - I've seen this suggestion elsewhere in the forum but unfortunately it doesn't work. The result is below, it moves the line but not to the position I need; the y-axes are still independent.

[audreygerred]

For your y-axis on the columns, is the min and max set to auto? Try setting a max that is higher than .2 (maybe try .6 or 1?). That should increase the axis on the right, which will make the columns appear shorter in comparison to the whole and would pop the 3 on the secondary axis above the columns.

[audreygerred]

Hi! In the Range section of your screenshot, toggle 'Align zeros' to on.

[CA-0205]

I am having the same issue. Why is this option gone? I used to use this option all the time. Aligning zero's only works for the lower bound. If the upper bound is too big of a difference than it scales it differently. Has anyone found a solution for this?

[CA-0205]

After playing around a bit, I think I found the solution:

On the Secondary y-axis format options - toggle Align zeros to on AND Values to off. If Values are already toggled to off, turn them on and then off again and it should line up.

[Wien]

Worked me too, thanks alot.

[PaulusD]

@CA-0205  legend! this was really pissing me off 😂

[Rydzyk]

Works well, unless it is a calculated field, then when you togle off Values the line on graph goes flat 😕 

[ddunne1]

Hi - I eventually found that if you toggle the Secondary y-axis Values on and then off again, it fixes it. Not exactly intuitive, but works!

[eligiuszHeller]

It odes not work. I.e. the secondary y-axis disappear, but the line is still located according to the secondary y-axis, does not correrale with the primary x-axis

[Elmore]

Thanks for this!

[lpetty421]

Thanks....not intuitive at all...so thanks for sharing...i spent far to long trying to find the turn off option.

[ghaines]

It used to be that sometimes secondary axis would be on even when it was showing as off.  So this is not a new problem, but the change in name just adds another level of abstraction that makes it basically impossible to fix by just fiddling with it.  Very annoying.