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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.