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?
@paulwasit is this continious? have you tried changing it to log?
post a pic of the issue that is helpful
@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,
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
@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.
Under Y-Axis (Column), scroll down and ensure that Show Secondary is set to OFF.
The same problem here, but this work. Thanks.
It Worked for me Thanks
Engage and empower students with Power BI!
Continue your learning in our online communities.
Travel to Melbourne and network with thousands of peers!
Check out what's new in the Power BI Community!