Forum Discussion
Gantt Chart - Sorting Issue
Hello,
I've an urgent issue in Gantt Chart.
Unfortunately we cannot solve the sort.
Initially we solved putting the number before task name, but if you see the task 6,7,8 is after the 050 but it should be after 005.
Please can somebody kindly help us?
It is really an urgent feature otherwise we should consider a different product.
19 Replies
Found a workaround on last version.
First you need to create a group field for which you want to sort. make sure lables given are in desired order (for ex. 00 , 01 ,02,03 etc... or AA,AB,AC,AD...etc).
After creating group with labels in desired order. drag that column in to field "Extra Information" highlighted below.
and then sort the group column as given below.
hope this will help
Thanks!
This really helped, thank you!
FINALLY GOT IT TO WORK
Assuming Excel Workbook as input data
Set WBS field to 'Text' format
Change WBS 1-9 to 01-09
01 02 03 04 05 06 07 08 09 10 10.1 10.2 10.2.1 10.3 10.3.1 10.4 Concatenate WBS and TASK Name in new Excel Column
=concat(WBS, " - ", Task)
Use WBS Task in Power BI 'Task' data
Using ellipses in upper right corner of visual, sort by WBS, sort order Ascending
Hello,
I am experiencing the same issue; using sort by another column in the modelling ribbon used to work but doesn't seem to work now. The problem doesn't affect other visualisations like the charts. Any help on this would be greatly appreciated.
Thanks
Hi All,
Not sure if you've all figured this out but I found a work around. If you create a sort structure within your table that actually sorts the Item Name items in the correct order you want then you can go to do the following:
- Go to the top of your gantt visual and select the 3 dots
- Select Sort Access
- Select Item Name instead of Earliest Due Date. If you've done the work on the back end table and got things in the right order there then the gantt will sort correctly. As you can see from the images below I was trying various ways to get the sort to work and stumbled upon the fix below.
Unfortunately this action does not affect any reaction to Gantt Chart, as you can see from the screen below (sorry but it is in italian) I choose ID column, then Sort by Column -> then I choose "Nome Task" (task name).
In the modeling i see that effectively the rows was sorted by the correct way, but Gantt completely ignore any sorting.
In Gantt Chart, no matter how you set the sort order for your column, it will sort the Categories based on StartDate only.
Regards,
Grouping was a resolution to the sorting of the Tasks, however with the latest update, this has become void. So the sorting doesn't change with order in the group but it sorts according to the start date.
Can anyone help with a work around or a solution? This is an urgent issue to be tackled.
Yes, but without success. In the old version the sort was bugged and removed in the last version that i've tried.
Regards.
