Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
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,
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
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.
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
It Worked for me Thanks
The same problem here, but this work. Thanks.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |