How to Arrange Column Headers in Table Matrix in a certain order

[Anonymous]

I have a dynamic table setup here, problem is I want the column headers to be in a specific order. This is a production schedule for job orders that go in a specific order through our facility. 

I want to arrange the columns in this order below which is the flow.. The raw data uses department ID numbers that refrences a lookup table with the name and Id's.

Job - Fabrication - Sub Assembly - Floors - Sides - Tailgates - Speciatly - Boxing - Rig Out - Paint/Wash - QC - Final Assembly

[amitchandak]

@Anonymous , Create a new column with department sequences and use that as a sort column

https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column

[Anonymous]

@amitchandak @Greg_Deckler @Anonymous 

I know how to create a column, but how do I create a department sequence?

The raw data looks like this..

[Anonymous]

I have tried all 3 responses and cant get it to sort properly.

[Greg_Deckler]

@Anonymous - There is this method - https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/963588#M428

[Anonymous]

HI @Anonymous 

Create another table with two columns as Seq and Dept.

In the Seq column number it as per your requirement.

Join these two tables on 1:many relationship and use the Seq column to arrange the columns in the report.