Rearranging in columns in Table Matrix visual

Hi Anonymous ,

Firstly, you may create a calculated table named 'SortTable' via button "Enter Data" under Home ribbon (assuming the sort order is like column [Order] below), then create relationship with your fact table with Both of Cross filter direction on related field.

Secondly, you may select on the status column of your fact table,  which contains values "In-Process", "Not Started" ,,etc,  go to Column tools ->Sort by column, choose the option 'SortTable'[Order].

For reference:

Sort by column in Power BI Desktop

Best Regards,

Amy 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.