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!
Hi Lora_0121
As we haven’t heard back from you, we wanted to kindly follow up to check if the suggestions provided by the community members for the issue worked. Please feel free to contact us if you have any further questions.
Thanks and regards