Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
Solved! Go to 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
Proud to be a Super User!
@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.
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
Proud to be a Super User!
@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.
@Anonymous , Rate is coming as text, change its data type to number and then try
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
98 | |
78 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |