Hi,
I currently have three Single Select columns from Airtable going into a PowerBi report. I noticed that my age column is numerically in order but my other two columns are not.
At first, the other two columns were number columns and the age column was a single select column. I have now updated the other two columns to be single select but this doesn’t fix my issue.
Somehow, PowerBi sees the 3 numbers coming in from Airtable as 10,4.5 even though Airtable is correct 4.5.10.
I have tried to add new columns in Airtable and start over in PowerBi but nothing has worked yet. Any thoughts?
The column in Airtable.
![Airtable Column Airtable Column](/t5/image/serverpage/image-id/3877i102829B091C674DD/image-size/large?v=v2&px=999)
This is the Customize menu for the column.
![Airtable Number Airtable Number](/t5/image/serverpage/image-id/3882iBD3F3E7C58C2F6C5/image-size/large?v=v2&px=999)
PowerBi
![PowerBi Number PowerBi Number](/t5/image/serverpage/image-id/3891iA667BADC9485AE29/image-size/large?v=v2&px=999)
Here is the correct Age column in both Airtable and PowerBi.
![Airtable Age Column Airtable Age Column](/t5/image/serverpage/image-id/3876iCC5DD7E8077C9F79/image-size/large?v=v2&px=999)
![Airtable Age Customize Correct Order Airtable Age Customize Correct Order](/t5/image/serverpage/image-id/3888i99FED3DD39C65C48/image-size/large?v=v2&px=999)
![PowerBi Age Correct PowerBi Age Correct](/t5/image/serverpage/image-id/3894i1B1E74AE90F4C47D/image-size/large?v=v2&px=999)