Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
88 | |
74 | |
69 | |
65 | |
58 |
User | Count |
---|---|
104 | |
94 | |
76 | |
62 | |
59 |