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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
procyon82
Resolver I
Resolver I

Aligning 2nd Y-axis with 'zero'

How do I make sure that the right Y-axis is zero where the left one is zero? Right now Y-Axis (Line) is set to 'automatic', but that seems to just set the middle where the average is.

 

TySOpi3[1].jpg

6 REPLIES 6
utnapishtem
Helper I
Helper I

I guess this has been fixed?  It took me a bit to find it, but in the Y axis formatting options, there's a switch for "Align Zeros".  

achinm45
Advocate IV
Advocate IV

Hi @procyon82

 

Try giving same range of values for Y axis .

Lets say your Y-axis on left ranges from -10 to 5,000.  Right Y-axis ranges from -1,500 to 10,000

 

Try defining axis range from -1,500 to 10,000 for both.

 

Regards,

Achin

Sean
Community Champion
Community Champion

@procyon82 you won't be able to perfectly align them but you can get the Secondary a bit closer to the line

 

Adjust the Primary Y-Axis value... (in you case I would first try the Primary to start at -300!)

 

This should raise the Secondary a bit - let me know!

 

Y-Axis Values.png

I've reported this to MS a while ago. Hopefully they'll fix it!

ankitpatira
Community Champion
Community Champion

@procyon82 can you advise which visual are you using ?

procyon82
Resolver I
Resolver I

Nobody?

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.