Forum Discussion
Custom sort order Gannt chart
Hi there
I'm trying to create a Gannt chart displaying project task names but sorted by index (to mimic the order in P4TW).
I can only see the option to sort the axis by task name, earliest finish or progress. Hoping the community can provide some insight!
Thanks in advance.
MIEKET You could use the 'Sort by column' functionality to sort the Task name by Index, then sort the Gantt by task name: https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column?tabs=powerbi-desktop
https://excelwithallison.blogspot.com/2021/11/custom-sort-order-for-text-columns-in.html
4 Replies
MIEKET You could use the 'Sort by column' functionality to sort the Task name by Index, then sort the Gantt by task name: https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column?tabs=powerbi-desktop
https://excelwithallison.blogspot.com/2021/11/custom-sort-order-for-text-columns-in.html
AllisonKennedy update on this: I added the visual from scratch and it's now displaying correctly.
Thanks for the assist!Thanks for the advice AllisonKennedy
Unfortunately, this does not seem to work for me. I followed the directions but the Gantt order remains unchanged (in alphabetical order).
Not keen to rename tasks so hoping there's another way.the solution above doesn't not solve an issue on a Gantt visual !
on power bi visual of gantt, i would like to order by wbs and not by alphabetic order - what should i do ?
