Sorting of values

Hi avidthinker 

Thank you for reaching out to the Microsoft Fabric Community Forum.

It looks like the sorting issue may be caused by mixed data types in your column. Some values (e.g., "5.29.1") are likely stored as text, while others (e.g., "8.03") are stored as numbers. This would explain why "8.03" is treated as larger than "5.29.1" when sorted.

Could you please try changing the column’s data type to text in your Dataflow and check if the sorting issue persists?
Thank you.