Percentage data wrongly imported from excel

[LinkeLoutje]

Hi,

As per title. When I add my file to PowerBI my percentages seem to become a factor 10 higher. Somehow the punctiation is wrongly interpreted.

Example:

The percentages are delivered as text: -15.0%

According to PowerBI the value is -1,5 and thus -150%

This doesn't make any sense to me... How can I make PowerBI interpret the -15.0% correctly?

Thanks!

[vanessafvg]

@LinkeLoutje thats because % should be expressed as 0.15 not 15,0.  % is a total from 100 or 1.0, everything below that should be 0.99 etc

[LinkeLoutje]

Thanks Vanessa. I do understand that a different expression would be better. However... The data is delivered as such and I will not be able to change that. Furthermore I'm mostly curious why PowerBI correctly assumes it is indeed % data and does seem to incorporate a comma, but somehow randomly chooses the position. 

[vanessafvg]

@LinkeLoutje maybe the problem is the comma?  maybe this is affected by your regional settings im not sure

[LinkeLoutje · Accepted solution]

@vanessafvg Thanks for your reply!

I've found a solution. There are 2 different methods of changing the datatype. From the ribbon you are only able to select the percentage value. Which results in the problem above. Surprisingly the right click on the column > change datatype gives the option to use a locale. Here I have chosen the percentage based on the US locale, which uses the ".". Now PowerBI properly recognises the percentage.

According to me the locale option should be added to the ribbon as well...

[ankar]

This didnt work for me. I dont see an option to change data type in right click options anymore.

[vanessafvg]

greatstuff!

[LinkeLoutje]

Sure is... Another option would be to select the locale of a source (which could very well be different from the locale I'd like to use) but that's not possible? Or am I mistaken?