Ask regarding whole number in Power Query Editor to the left area

[NikAmalAiman]

Hi guys!

Just want to ask regarding the Numbers inside this column.

Currently I'm doing the Employee Card and I want to show the Age for each Employee is the same as Employee ID, Employee Name, Race,  Religion and Hired Date. You all have any idea? Thank you.

[v-yiruan-msft · Accepted solution]

Hi @NikAmalAiman ,

Actually, it depends on the data type. If the data type of the field is Text type, it will display in the left side of column. And the data type of column [AGE] is Whole Number type, then it should display in the right side of column. This is by design. 

Data types in Power Query - Power Query | Microsoft Learn

Best Regards

[NikAmalAiman]

Realign* with the others