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
Super User
Super User

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

 

 

Super User
Super User

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