Forum Discussion
PowerBI Service - Refreshing the data via Service displays extra zeros
Hi Anonymous
I would suggest that there is something going on with either your data source or filters that are causing this.
If it was me I would look into this, because once that is fixed everything else would drop into place?
Super UserHi Anonymous
That is really weird.
What happens if you create a measure, does that display the values correctly?
It not what happens if you create a measure and divide it by the number of extra zeros and see if that solves your issue?
Hey GilbertQ !
Thank you very much for the suggestion. Some measures are displaying correctly, while some of the are very skewed (due to the fact that some columns have the extra zeros). I have created a new measure to display the marketing investment using FORMAT and DIVIDE to eliminate the extra zeros and that has helped. However, I have noticed some big irregularities in the data set that I do not understand at all. Please see a snippet below.
The expected value would be 10.5 M, definitely not the value that shows up in there. 😁
This leads me to belive that there is an issue with the underlying data but, I do not seem to encounter this issue in Power BI Desktop which confuses me a lot.
I believe that the zeros issue can be solved by creating measures but I still do not understand why my data changes so much after the refresh in Power BI Service 🤔