cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
paulwasit
Frequent Visitor

Line and stacked column chart - force shared Y-axis

 

I am using a Line and stacked column chart, and it seems that lines and columns have independent Y-axes. 

 

The start & end values automatically align when the range is similar between lines and columns, but not when there are large discrepancies.

 

I know that I can manually add custom start & end values, but the graph would not scale properly when filters are applied. 

 

Is there a way to force a shared Y-axis?

8 REPLIES 8
vanessafvg
Super User
Super User

@paulwasit is this continious?  have you tried changing it to log?

 

post a pic of the issue that is helpful





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




@vanessafvg it is continuous; my X-axis are dates.

 

The following image shows my problem: it seems that line and column have the same values, but only because they do not have the same Y-axis range,

 

Capture.PNG

 

I would like them to have a shared Y-axis, so the comparison is easy even when filters are applied. 

 

 

@paulwasit can you show a screen shot of how you placing them on the visual?  might be easier to share your pbix if you can





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




@vanessafvg I cannot share my pbix but here is the capture of my settings. I have fixed the start values of both Y-axes at zero but not the end values as they need to rescale when filters are applied.

 

 

Capture.PNG

Under Y-Axis (Column), scroll down and ensure that Show Secondary is set to OFF

It will work only if you do not force start of both y axis at 0

Anonymous
Not applicable

It Worked for me Thanks 

Anonymous
Not applicable

The same problem here, but this work. Thanks.

 

 

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors