Forum Discussion
Data Formatting Issue : How to fix Scientific Value Shown on a value that supposed to be Zero
Hello everyone,
I am experiencing a data formatting issue where a value that is supposed to be 0 is displayed in scientific notation instead.
I have already checked and adjusted the data formatting settings, attached screenshots showing:
The result displayed in the report
The data formatting settings configuration
I use the same formatting for the other column and the value was correct.
Could you please advise on what might be causing this behavior?
Thank you very much for your help.
6 Replies
Power BI (DAX) uses floating-point math. After calculations (division, subtraction, percentages, averages, etc.), values that should be zero often end up as something like: 0.0000000000046. When the number is extremely small, Power BI switches to scientific notation to represent it. To fix it you need to correct your column format setting. Instead of using "general", use "Whole Number" or "Decimal" depending on your need.
Hi cengizhanarslan , thanks for your reply, but here as on my snapshot the data format already set to whole number.. for more context to manage the pbi i divide the pbix file into 2 part one for managing the dataset and one for the report, in this case in pbix dataset file i already set the data format to whole number but in the pbix reporting file i check it is set to general but i cannot update it it is lock..
do you have any other insight on this? thanks..You need to change your column format in your dataset not thin report. Thin report is the one that is live connected to your semantic model in service and you cannot change anything on the model by using a thin report.
