Combo Chart Disable Secondary Y Axis

[mboucher_rcr]

Hi,

I have a line/bar combo chart and I want to disable the secondary Y axis so both the bars and lines run off the same Y axis.

According to MS article https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-combo-chart?tabs=powerbi-d... there is an on/off toggle switch against Secondary y-axis, however I am not seeing this option.

Can anyone please help?

Thanks!

[rmaxix]

Pretty sure this issue didn't used to exist. At some point an update has removed the option to turn off the secondary axis. As of Jan 2025 this still hasn;t been resolved. A weird and simple issue to have not addressed.

[Anonymous · Accepted solution]

Hi @mboucher_rcr 

I would like to apologize for the belated reply.

Have you solved your problem? If not, try the following steps:

The following screenshot is without closing the Values of Secondary Y Axis.

You can turn off the button as shown so that the Column y-axis and the Line y-axis share a common y-axis.

Is this the result you expect?

Best Regards,
Community Support Team _Yuliax

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

[JohanWelgemoed]

There seems to be a bug on the visual, the Values of Secondary Y Axis seems to be switched on although it doesnt display as such, switch it on and off again the Secondary Y Axis will be off.

[rmaxix]

This solution works, however by default the Values field was Off and to get this to work I needed to toggle it on and then off again. 

[chris1579]

Exactly the same experience; so it's both a bug and a dreadful piece of interface design.

[jefminnen]

It appears that this solution does not always work (I'm on the february 2024 release).

I made sure that both minimum and maximum of Y-axis and secondary Y-axis are on "Auto", "Align Zero's" is on, values of the secondary Y-axis is turned off, but I still get different scales for line and bars.

A workaround could be to calculate the maximum of both set of bars and the line, and add that to the maximum of the range, but that is a lot of work, and needs to be done for every combination of measures used. In the past it was sufficient to uncheck the "show secondary axis" check box to get the wanted result.

Please bring this option back.

[pratyashasamal]

Hi @mboucher_rcr ,
Secondary y-axis toggle button can be set to On to display options for formatting the line chart portion of the combo chart not to disable the secondary chart . 
If you dont need the secondary axis just remove it from the secondary axis. 
As you the secondary y axis is not visible , you can update th version of your power bi desktop.
Thanks,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

[mboucher_rcr]

Hi,

There doesn't seem to be any update available to my version: 2.124.1554.0 64-bit (December 2023)

There is no toggle button visible. I don't need the second axis, but I do need the lines showing, I just want the columns and lines to share the same Y axis.