Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi
One sorting problem. How to sort text column like "Sorted version".
Orginal | Sorted version |
1. John | 1. John |
10. John | 2. James |
2. James | 3. John |
3. John | 4. John |
4. John | 5. James |
5. James | 6. John |
6. John | 7. John |
7. John | 8. James |
8. James | 9. John |
9. John | 10. John |
Solved! Go to Solution.
Using Power Query.
Split the column using . as the separator.
Sort the data on the numeric column.
Merge the columns back together.
OR
Why continue to work with the data in the original format? Split the column, treat text as text, numeric as numeric and live happily ever after.
Go to PowerQuery Editor.
Duplicate the Column. Extract the Id's using Text Before Delimiter. Later convert the datatype of Id's as Whole Numeric. Click on Close and Apply.
To sort the data in visual. Sort the Data on bases of Id's Column.
Thanks, could I sort them also in slicer?
Hi @blossfeld ,
Yes. After you have sorted the original column based on ID number in Data view mode, it would be dispalyed in correct order in slicer, too.
In Power Query, duplicate the original column, split it by delimiter ".", remove unnecessary columns.
In data view, change the default "Sort by" column to [ID].
Add column into slicer.
Best regards,
Yuliana Gu
Using Power Query.
Split the column using . as the separator.
Sort the data on the numeric column.
Merge the columns back together.
OR
Why continue to work with the data in the original format? Split the column, treat text as text, numeric as numeric and live happily ever after.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |