If all values are the same we execute special logic to show at least 3 tick values. Setting an End value will work, I set start to 0 and end to 1 and the repro example worked fine with 3 zero values. The fallback behavior for all-same-values is By Design right now and we have no immediate plans to change this.
setting an End value is not an option for us. Why does this work with an End value but not with a Start value? Couldn't this be changed to still showing 3 tick values but with the lowest tick value equal to the Start value?
When line chart has no data, the -1, 0, 1 default y-axis values just looks bad or weird. It looks like something is in error or otherwise unexpected has happened.
It would just look better with 0, 1 y-axis values or 0, 1, 2 y-axis values if your logic requires three points.
The sensible way to let user to make this choice is to allow setting Start = 0, to force chart that has no data to show 0, 1 y-axis values or 0, 1, 2 y-axis values if your logic requires three points.
(I am using Version: 2.100.684.0 64-bit (December, 2021))
I am also having this issue. Has there been any resolution? Having a y-axis go from -100% to +100% for something that can't be negative % look really unprofessional in my dashboard.
Has this issue been resolved by Microsoft? I am having this issue that the axis auto switch back to -100% to +100% like the above, when the data is showing all-same-value. This default setting is really bad.