Forum Discussion
How to Customize Sorting
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 there,
Yes, besides creating a custom sort column, you have a couple of other options to control sort order in Power BI:
Sort by Column in the Same Table
If your categories are already in a table, you can add a calculated column using DAX that assigns numbers to your text values (for example: Medium = 1, High = 2, Low = 3). Then use Sort by Column to apply the order.Use a Manual Sort in a Visual
In some visuals (like bar or column charts), you can manually drag the categories into the order you want by sorting on the axis field — this is limited but useful for small lists.Leverage a Switch Function in DAX
You can create a measure with a SWITCH statement to define the order logic.
Each method depends on whether you want the order to apply just in a visual or consistently across your model.
Hope this helps!