Column shows number instead of zero

[mohd78]

I have created a measurement field on my data from two different columns. After creating the new measurement, the data on the power bi show numbers, but the data from the excel file shows zero. Not sure what I need to do with it  

The circled number is not in the excel file; those numbers are zeros in the excel file 

[FreemanZ]

In Excel, if you select a cell, say $2.5, what do you see in the formula bar?

[mohd78]

the excel file shows 0 and not 2.5. this is the problem am talking about. why it shows 2.5 since the excel file says 0.00

[FreemanZ]

is the value color identical to the background?

[mohd78]

It's just a color. so indicate that all the color is white