Forum Discussion
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 item that sells 804.8
Incorrect Filtering
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
3 Replies
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
As 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
As 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
