Forum Discussion
Percentage data wrongly imported from excel
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...
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.
LinkeLoutje maybe the problem is the comma? maybe this is affected by your regional settings im not sure
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...
greatstuff!
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?
This didnt work for me. I dont see an option to change data type in right click options anymore.
