Weird rounding issue

[Cornwalls]

I am having a weird rounding issue. My visual will not show the actual value that is in the dataset.

The expected value it should show i the visual is 0.5 - but no matter what i try it stays at 1.0. I have tried changing the formatting in the data source and in the dataset, added decimal places to 2. Tried a custom column and tried creating a new visual. I believe it was changing the decimal places to 2 that fixed it last night but today in trying that its not budging.  

Visual (displaying incorrectly):

Datasource (Sharepoint List) displays correctly and says 0.5:

Dataset (displays correctly 0.5):

Any help would be greatly appreciated!!!

[Cornwalls]

Thank you a million @christinepayton ! waking up this morning and switching one of the columns from whole number to decimal number again coupled with with the setting 2 decimal places seems to have fixed it!

I cant say i understand the logic, i only changed whole number to decimal number on one column however it applied the fix across all four columns - so three columns are still set to whole number yet they all changed upon changing one column to decimal number. 

[christinepayton · Accepted solution]

In Power Query, is it being set to whole number type? Sometimes with the auto-type assignment if it only finds whole numbers in the first x rows it'll do that and you have to manually go change it to decimal in that first change-type step in Power Query. If it's whole number and you've added decimal places, it would present as you describe. 🙂