Forum Discussion
Data Formatting Issue : How to fix Scientific Value Shown on a value that supposed to be Zero
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.
Hi Asyifa ,
Thanks for the update, since this report is connected to a semantic model and you don’t have permission to change the dataset, the scientific notation you’re seeing is most likely happening because the value isn’t truly zero. Power BI sometimes produces extremely tiny numbers (like 0.0000000001) due to calculation precision, and formatting alone won’t hide that. A simple workaround is to create a new measure in the report that rounds the value or treats very small numbers as zero, then use that new measure in your visuals with the format you want. This way you can fix how the number displays without needing any changes to the dataset.Hi Asyifa ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.
