Forum Discussion
Power BI does not recognize my numeric fields nor does it let me change them
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
I'm sorry it was pointing to an older file, I now havve it pointing to the correct file and it does show it as abc, this is what I see when I do a dropdown:
do I need to change the blanks to something else? Maybe 0 - zeroes?
Community ChampionAnonymous
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