The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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
@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
@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..
I have tried all 3 responses and cant get it to sort properly.
@Anonymous - There is this method - https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/963588#M428
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.