Power BI messing the column formats

[msof07]

Hi!

among my data I have column of percentages with different values but when I load it into desktop I check the filter and I only have -1, 0, 1, and 2, 3, 4..... it's not the first time I upload this book and today it appears like this, what could've happened? My percentages range from -50 to 200%, a lot of different numbers why is it transforming them into those? What can I do?

[ribisht17]

@msof07 

Please check the format 

Thanks,

Ritesh

[msof07]

Hi Ritesh, I have changed the format but it doesn't recover my previous percentages not even as decimals. If I change the format like that it simply changes like -100%, 200%, etc. It's straight up deleting my data and substituting them for those whole numbers.