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.
Hi,
I am new to power bi. I have a column which have decimal values. But, the datatype is text. When I tried to convert the datatype to decimal power-bi query editors throws below error.
DataFormat.Error: We couldn't convert to Number.
Details:
−0.38
(note: It happens to only negative numbers)
Please help
Solved! Go to Solution.
I have a feeling that that "−" character isn't same as "-". As you can see, it's a bit wider. Did you get from Web.Page? Maybe you can do "Right click on columns > Replace Values" and replace "−"s with "-"s.
Hi,
I am new to power bi. I have a column which have decimal values. But, the datatype is text. When I tried to convert the datatype to decimal power-bi query editors throws below error.
DataFormat.Error: We couldn't convert to Number.
Details:
−0.38
(note: It happens to only negative numbers)
Please help
As I tested, PowerBI can certainly convert the text "negative numbers" into a negative number, so there's something else going on here.
I import the data into Power BI as following screenshot.
Please check the negative sign in the string if there is actually some kind of Unicode character, or that there's something which looks like a digit in the text but is actually a letter? Would you be able to share your data with us for further analysis?
Best Regards,
Angelia
Thanks Angelia & Arify,
The issue is with "−" charactor. I replaced it with "-" . Now Everything works fine
I have a feeling that that "−" character isn't same as "-". As you can see, it's a bit wider. Did you get from Web.Page? Maybe you can do "Right click on columns > Replace Values" and replace "−"s with "-"s.
Thanks arify,
it worked for me as well.
Kind Regards
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |