Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.