Hi @sjpaq ,
When you're editing a report in Power BI, you can choose a column to define the sort order of another column.
Here's a common example. You have a Month Name column, and when you add it to a visual, the months are being sorted alphabetically: April, August, December, February, and so on. However, you want them to be sorted chronologically. This article shows how to set the sort order of one column by a different column, in Power BI Desktop or in the Power BI service.
For more details, please refer to:
Sort one column by another column in Power BI - Power BI | Microsoft Learn
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.