Custom Column sorting in multiple header in power bi

[Anonymous]

Hi All,

I have a multiple header matrix created in Power BI created from a table. I am getting the bottom most column in ascending sort automatically. Is there a way to custom sort it, I am sharing the column header below:

Appreciate quick help: I am trying to set the order in External Joiner, Internal Joiner, External Leavers, Internal Leavers, and Current staff sequence. 

Thanks,
Shubham

[Fowmy · Accepted solution]

@Anonymous 

You can add a sort column to your table and sort the particular column based on that. 
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column

Please share a sample or dummy file to better understand your table 

[Anonymous]

Thanks a lot for the prompt response @Fowmy 🙂