Forum Discussion
Solved
Percentage data wrongly imported from excel
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 te...
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?