Forum Discussion
Data Formatting Issue : How to fix Scientific Value Shown on a value that supposed to be Zero
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..
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.Hi Asyifa ,
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you