Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
jllane
New Member

Visual using secondary axis but secondary axis is turned off

I have a line and stacked column chart and all values are using the primary axis because they are on the same scale. Just recently we have tested an upgrade to May 2020 Report Server and I noticed that the visual in this test version is using the secondary axis for the line and the zeros are not aligned on primary and secondary making the value for the line higher than the value on the primary axis--note the secondary axis is not displaying. On desktop, it displays correctly and still displays correctly on our older version production site.  I do not want to display the secondary axis and have not been able to figure out how to fix this but need to do so before we move the new version to production. Any thoughts?

3 REPLIES 3
smit3262
Regular Visitor

This doesnt work for me - even when turned off the secondary line isnt following the rules of the primary y-axis

Had the same issue - try activating align zeroes (even when secondary achsis is turned off) as d_gosbell mentioned. This did the trick for me. 

d_gosbell
Super User
Super User

If you go into the formatting options for your visual, in the Y-Axis settings underneath the "Show Secondary" option there are values for Start and End, these options relate to the secondard (line) Y-Axis, you should delete any values in these settings if you want the axis to be synchronized. I had a user who had accidentally changed these settings as it was not clear that they only related to the secondary y-axis.

 

If this does not work, when you enable the secondary axis there is an "align zeros" option, so try enabling the secondary axis, turning on "align zeros" then hidding the secondary axis and see if this helps. (if it does it's probably a bug, but it might let you work around this issue)

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.