Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
@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-deskto...
https://excelwithallison.blogspot.com/2021/11/custom-sort-order-for-text-columns-in.html
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
@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.
@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-deskto...
https://excelwithallison.blogspot.com/2021/11/custom-sort-order-for-text-columns-in.html
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com