custom sort question

[PaisleyMike]

Hello 

I have  a bar chart with  above average, average, below average, very high, very low 

The way they are sorted are alphabetical 

is there a way to set a custom sort to place them 

very low, below average, average, above average, very high

Thank you 

[Anonymous · Accepted solution]

HI @PaisleyMike,

Please create a calculate column with custom sort order, then you can use sort by column feature to use new column as sort order.

Sort by column in Power BI Desktop

Notice: custom sort order should has similar as current group category.(if sort order will break current group, it can't used as 'sort by column')

Regards,
Xiaoxin Sheng