Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 @pranit828
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.
Hope it resolves your issue? Did I answer your question? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!! Linkedin Profile |
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |