Data not Refreshing Properly after Type Change

[julialynnes]

Hello! I am working on a PowerBI report (not yet published, still in progress). I noticed my calculations were incorrect in calculating a monetary sum because I had mistakenly originally set the data type for a line to be "whole number" when it should have been fixed decimal as not all of the prices were whole, rounded numbers and some included cents (ie $12.43 instead of $12). I went into "Transform Data" and changed the Data Type to Fixed Decimal and hit close and apply, and then I hit refresh. However, the data is not updating to include the cents and is still using the whole numbers. I checked that the data type change had saved and it did, and there don't seem to be any connection issues between the live sheet and the PowerBI desktop. I also tried restarting the program to see if it was just a timing error. Is there anyway to get the data to refresh so that it includes the decimals as it should? Thank you!

[vicky_]

Check the number format is set to either General or Decimal number (while the type is decimal, it might still be formatted as a whole number) 

This is purely a display thing btw. There might be other places in your calculations (measures or columns or even in the formatting of the visual elements) where you might be rounding or formatting as a whole number.

[julialynnes]

Thanks, your change did at least add the decimal points. However, it is still saying .00 even on data where there should be cents on the dollar. Is there another way to get this to update properly? thanks so much for your help, I didn't even notice the format option!