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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Any way to "force" y-axis scale sync or match on a combo chart?

So I notice if you make a stacked column / line chart by default the y-axis scale is totally different between the columns and the lines. This can be very confusing - especially when they are the same metrics (one is weekly or monthly while the others are a trend, maybe a goal line, etc.)

 

If you turn on "show secondary" and enable zoom slides you at least have an indication of the differnet scales, and can manually fiddle with the sliders to try and get them close to same scale, but it's far from exact.

 

Lastly, I discovered that if you go to "Y-axis (Line)" and for the End value select the values used for the columns it automatically brings the line y-axis close(er) to the column y-axis, but it's not really the same scale and in some cases is even further off.

 

Is there a way to actually sync these two scales, and if not, why isn't there? For combo charts that have discreet (column)_ and trends of the same data the option to enable y-axis sync or lock should be mandatory!

7 REPLIES 7
AlexisOlson
Super User
Super User

Can you not just turn off the secondary axis entirely? If there is no secondary axis, they'd have to be on the same scale (make sure to clear any values you may have in the Range).

Anonymous
Not applicable

From what I can tell, turning off "show secondary" only hides/removes the secondary y-axis legend (scale). It doesn't change the actual scale of the y-axis the lines are in, it's just not obvious that they're on two different scales because you don't have the second legend to show how far off they are. Of course if you know the data, it's still pretty clear though...

I have seen that behavior too but it's not completely consistent. Humor me and try Reverting to default the Secondary y-axis and then try toggling it on and off a couple of times to see if it changes to what you want.

Anonymous
Not applicable

Do you mean just toggle the "show secondary" on and off a few times? If so, no change.

 

If I misunderstood you please clarify.

If you have a sample file where you reproduce this issue, I'd be interested in taking a look.

Anonymous
Not applicable

Hmm, not sure. The file is huge because it has a LOT of data, and a lot of that data has customer info in it. I can make a copy and see what happens if I try deleting some of the tables...

That is what I meant. It works for me, at least in some cases. Sorry to hear it didn't help.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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