I have a line and stacked column chart and all values are using the primary axis because they are on the same scale. Just recently we have tested an upgrade to May 2020 Report Server and I noticed that the visual in this test version is using the secondary axis for the line and the zeros are not aligned on primary and secondary making the value for the line higher than the value on the primary axis--note the secondary axis is not displaying. On desktop, it displays correctly and still displays correctly on our older version production site. I do not want to display the secondary axis and have not been able to figure out how to fix this but need to do so before we move the new version to production. Any thoughts?
If you go into the formatting options for your visual, in the Y-Axis settings underneath the "Show Secondary" option there are values for Start and End, these options relate to the secondard (line) Y-Axis, you should delete any values in these settings if you want the axis to be synchronized. I had a user who had accidentally changed these settings as it was not clear that they only related to the secondary y-axis.
If this does not work, when you enable the secondary axis there is an "align zeros" option, so try enabling the secondary axis, turning on "align zeros" then hidding the secondary axis and see if this helps. (if it does it's probably a bug, but it might let you work around this issue)
User | Count |
---|---|
25 | |
7 | |
2 | |
2 | |
1 |
User | Count |
---|---|
26 | |
10 | |
5 | |
3 | |
2 |