Incorrect Sorting

[0experienceinBI]

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

[v-juanli-msft]

Hi @0experienceinBI

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

[v-juanli-msft]

Hi @0experienceinBI

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

[OwenAuger · Accepted solution]

@0experienceinBI

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