Value not given as number

[sr12]

Hello everyone,

I have the following columns that are shown in the attached picture, they all have the same data type of decimal number, but the "Order" column doesnt have a number value while all the other columns do. I tried to refresh the table and remove the whole thing and add it back but its not working. How can i fix this?

[amitchandak · Accepted solution]

@sr12 , check its data type in the power query. If that is any; change it to decimal. Also make sure same is done in column tools

[sr12]

@amitchandak 

Yes in power query the data type is decimal number, but its still not working. Where is column tools?

[amitchandak]

@sr12 , when you click on the column. You should see that or should be there on top Tabs (Home, file etc. At the end)