Forum Discussion
Solved
How to Customize Sorting
Hello. Can you tell me how to sort categories in text format? For example, there are categories like low, medium, and high. I want to fix the sort order as medium, high, and low. I know how t...
Hay Lora_0121 as you already know the cool way "Sort by Column" to sort any text categorical data like "Low, Medium, High". Here are some other methods you can try:
- Use calculated column with help of dax
- Create a table in Power Query with index or conditional columns
- Enter data and then create sort by columns
I think these are the ways to solve sort by categorical columns and you are in good stage. You only know different methods or is there any specefic functionality you want to achieve that, the bese options Sort by Column is not helping you?
Is it helped? ✔ Give a Kudo • Mark as Solution – help others too!
You've already done it. The column itself can be sorted alphabetically or using a custom sort column or, if together with a measure, the measure itself (eg. sum of sales, transaction count, etc). No other way.