Forum Discussion
Solved
Incorrect Sorting
Hello, Background: I am pulling data from an OData source. I find it strange that my data will no sort properly. See photo: For example, an item that sold only 9 units is listed above a an it...
At a glance, your Sales_Qty and Profit columns appear to be Text data type (based on the sort order in the table and the fact that they are left-aligned).
Within Power Query, after importing from the OData source, you should change those columns to a numerical type (e.g. Decimal).
Then they should sort correctly
Regards,
Owen
v-juanli-msft
Community Support
Community SupportAs tested, If I set "sold only" column as "text" for data type, then the order for this column is like yours, But after I convert this column to "number" data type, it sorts correctly.
Best Regards
Maggie