Custom sort in power bi

[Gautham A]

Hi Team,
I have a column which contains values with week number and fiscal year.(Ex: WK-2 FY 22). I want to sort this column in visual. I guess we have to create a custom column. But I'm not sure of the logic? Can someone help on this?

 

[alansidman]

What does "sort in visual" mean? Why not split the field into two fields and sort accordingly? If you then need the data in the original form, then combine the split columns back together after sorting.