cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
crawfe
Helper I
Helper I

Can you sync and float the maximum of Y and Y2 axes (Bar-Line chart)?

Hi. I would like to sync my Y and Y2 axes in Float (max = Auto) mode. Is there a feature or a work-around for this?  Often you need to visualize the impact of the primary Y axis on the secondary (Y2) axis, on the same scale. You can arbitrarily set both axes' maximum. But when a slicer drastically reduces the size of the data, the resulting chart shrinks too much to be usable. (This seems like the feature should be a checkbox!) Thanks!

1 ACCEPTED SOLUTION
crawfe
Helper I
Helper I

...I found a solution that worked (It seemed that it took a couple of times on/off with the secopndary axis button to unscramble a frozen setting).  Turn secondary axis on; set align zeros to on, turn off secondary axis. Set both min/max to auto.  My line scale now does follow my columns scale. . I post it here for reference....

View solution in original post

1 REPLY 1
crawfe
Helper I
Helper I

...I found a solution that worked (It seemed that it took a couple of times on/off with the secopndary axis button to unscramble a frozen setting).  Turn secondary axis on; set align zeros to on, turn off secondary axis. Set both min/max to auto.  My line scale now does follow my columns scale. . I post it here for reference....

View solution in original post

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Top Solution Authors
Top Kudoed Authors