Converting wrongly formatted percentages to proper decimals

[Anonymous]

I am trying to build a dashboard using OECD's unemployment rate from here: https://data.oecd.org/unemp/unemployment-rate.htm#indicator-chart

Problem is the rate gets wrongly converted to whole numbers when downloading as csv and importing into PBI.

I've been trying stuff like text.padstart but not all the numbers are of the same length. Fx:

[PhilipTreacy · Accepted solution]

Hi @Anonymous 

I don't know what CSV you are working with.  I downloaded 4 or 5 from that site and none of them match the data in your screenshots.

Can you please share or indicate exactly what data you are using.

Thanks

Phil

[PhilipTreacy · Accepted solution]

Hi @Anonymous 

I don't know what CSV you are working with.  I downloaded 4 or 5 from that site and none of them match the data in your screenshots.

Can you please share or indicate exactly what data you are using.

Thanks

Phil

[Anonymous · Accepted solution]

@PhilipTreacyYour answer lead me to a workaround. I figured it was just my excel messing it up so i downloaded as txt file, imported into PBI, made sure to not recognize data types, manually split the columns and replaced the dots in the Value column with commas. Then I changed type to decimals and finally prefixed with the percentage sign.

[amitchandak]

@Anonymous , Rate is coming as text, change its data type to number and then try

[Anonymous]

@amitchandakI changed it to text myself to try concatenating with a column of 0.0's. It's the same when its a number unfortunetaly