cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
paulwasit Frequent Visitor
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?

7 REPLIES 7
vanessafvg Super Contributor
Super Contributor

Re: Line and stacked column chart - force shared Y-axis

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

 

post a pic of the issue that is helpful


Did I answer your question? Mark my post as a solution.
Proud a to be a Datanaut!
Highlighted
paulwasit Frequent Visitor
Frequent Visitor

Re: Line and stacked column chart - force shared Y-axis

@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. 

 

 

vanessafvg Super Contributor
Super Contributor

Re: Line and stacked column chart - force shared Y-axis

@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


Did I answer your question? Mark my post as a solution.
Proud a to be a Datanaut!
paulwasit Frequent Visitor
Frequent Visitor

Re: Line and stacked column chart - force shared Y-axis

@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

MF_Wong Frequent Visitor
Frequent Visitor

Re: Line and stacked column chart - force shared Y-axis

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

juliarossberg Frequent Visitor
Frequent Visitor

Re: Line and stacked column chart - force shared Y-axis

The same problem here, but this work. Thanks.

 

 

Vinith_s Frequent Visitor
Frequent Visitor

Re: Line and stacked column chart - force shared Y-axis

It Worked for me Thanks 

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 94 members 1,696 guests
Please welcome our newest community members: