Help, data type

[Anonymous]

My "Yr 1 ROI" become 0.0 or 1.0 or 2.0, although the original data is correct. My "3 Yrs ROI" is exactly the same format but show up properly.  

any1 know why?

[v-yuezhe-msft]

Hi @Anonymous,

Could you please describe more details about your scenario? We need to know the data type of "Yr 1 ROI" column in your source file and if you make any changes for the column in Power BI Desktop.

Based on my test, if you change the type of "Yr 1 ROI" column to whole number and then Decimal number in Data View of Power BI Desktop, the "Yr 1 ROI" column will not show up properly.

Thanks,
Lydia Zhang

[Anonymous]

"Yr 1 ROI" column in source file = Number

"Yr 1 ROI" column in PBI = Decimal Number

they are probably on whole number before, but I changed them back.  "3 Yrs ROI" works fine but not "Yr 1 ROI", they are same calculation and format in both excel and PBI.

[fabiocesarei]

Hi , can you attach a small data set?

Fabio

[Anonymous]

@fabiocesarei how to attach data set?  i've got a small sample in excel, how can i attach it here? 

many thanks. 

[fabiocesarei]

hi, I do not find the button "attach", try to load it on google drive or the like and enter the share link

[fabiocesarei]

hello , can you bring the real value of the field and the format of the column on the table ?