Forum Discussion
Power BI does not recognize my numeric fields nor does it let me change them
I've read different posts to fix the issue with how to get Power BI to recognize numeric fields but all I get is errors that I cannot change them to whole of decimal fields. I even modified the fiel...
Anonymous
As you can see for the field heading the data type of the field is text ('ABC')
To convert it to numeric please do the following steps:
1. Right click on the column --> Replace Values
2. Leave 'Value to find' box empty and in 'Replace With' box add a numeric value that you want (zero for example)
3. Click OK
then
1. Right click on column again
2. Change Type --> Whole number
3. Done
mahoneypat
Microsoft Employee
Microsoft EmployeeOpen the query editor (click on Transform Data) and highlight your column with numbers. On the Transform tab under Format, try to use Trim and/or Clean on that column before you convert to number. Also, what is the error message you see? Can you paste a screen grab of it, if that doesn't work?
Regards,
Pat