The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
User | Count |
---|---|
75 | |
70 | |
39 | |
30 | |
28 |
User | Count |
---|---|
104 | |
95 | |
51 | |
48 | |
46 |