Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
MIEKET
Regular Visitor

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.

1 ACCEPTED SOLUTION
AllisonKennedy
Super User
Super User

@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 


Please @mention me in your reply if you want a response.

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

View solution in original post

3 REPLIES 3
MIEKET
Regular Visitor

@AllisonKennedy update on this: I added the visual from scratch and it's now displaying correctly.
Thanks for the assist!

MIEKET
Regular Visitor

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.

AllisonKennedy
Super User
Super User

@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 


Please @mention me in your reply if you want a response.

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

Helpful resources

Announcements
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.