Negative y axis appears when displaying small values, less than 1 using scientific notation
We deal with results that are small values less than 1. They are not negative numbers. But they are often in the range of 1x10^-2 to 1x10^-12 values. We have been using PowerBI for the last year. Recently in the last month it was noticed that our charts of these numbers create a false negative axis. This makes the charts unreadable. see figure "example of initial problem".
We have tried setting the min value to 0 but that does not solve it. We have found that increasing the significant figures of the value to 4 or 5 helps temporarily. see figure "example of fix when increase decimals displayed...".
However this only works initially. If the user then selects a filter that reduces the dataset, then the problem returns - see figure "example of problem return..."
We have a large range of values (all less than 1) to display so we cannot increase the decimals of the scientific notation further - 4 or 5 digits are already too many to display anyway given the uncertainty of the values to begin with.
We are not sure when this problem started; we did not notice it in the spring or early summer. So it must be a new issue that started sometime in the summer. Sorry we cannot comment on which version.
3 Comments
- v-haibl-msft
Microsoft Employee
If all data are less than 1, please leave Start as Auto and End to 1 for Y-Axis to see if it works.
Best Regards,
Herbert - zencNew Member
Thanks Herbert. Tried this and does not solve problem. The values we are displaying are very small in range of 1x10^-3 to 1x10^-9. So when I put the End value to 1, the y-axis scale only shows 0 to 1 and that means my bars disappear as they are so small. I tried putting in end values of 0.1 (same problem as 1); 0.01 is better but the problem is that the sum of my values sometimes would be greater than this; 0.001 causes the negative axis to reappear.
- C_PfeilNew MemberMaybe you enter the limits for the axis in the format like 1e-10