Forum Discussion
Value not given as number
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?
Anonymous , 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
3 Replies
- amitchandak
Super User
Anonymous , 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
Yes in power query the data type is decimal number, but its still not working. Where is column tools?
- amitchandak
Anonymous , when you click on the column. You should see that or should be there on top Tabs (Home, file etc. At the end)