Sorting issue

Hi Jaspreet99 

In Power BI, text fields sort alphabetically by default. To apply a custom sort order (High >> Medium >> Low):

1. Create a SortOrder column (numeric) like:

    High = 1

    Medium = 2

    Low = 3

2. Create column:

SortOrder =
SWITCH (
    TRUE(),
    Categories[Category] = "High", 1,
    Categories[Category] = "Medium", 2,
    Categories[Category] = "Low", 3,
     4
)

3. Select the Category column >> Column tools >> Sort by Column >> choose SortOrder.

Now visuals will show High >> Medium >> Low instead of alphabetical.