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...
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?