Forum Discussion

Boseca's avatar
Boseca
Regular Visitor
9 years ago

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 ...
Anonymous's avatar
Anonymous
Not applicable
9 years ago

On the Modeling ribbon you will find an option to Sort a column... by another column.  I would try that out...

 

  • Mule's avatar
    Mule
    New Member
    9 years ago

    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

    • dlandry's avatar
      dlandry
      Icon for Helper I rankHelper I
      4 years ago

      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:

      1. Go to the top of your gantt visual and select the 3 dots
      2. Select Sort Access
      3. 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.

       

       

       

       

  • Boseca's avatar
    Boseca
    Regular Visitor
    9 years ago

    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.

     

     

     

    • v-sihou-msft's avatar
      v-sihou-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      9 years ago

      Boseca

       

      In Gantt Chart, no matter how you set the sort order for your column, it will sort the Categories based on StartDate only.

       

      Regards,

      • Mule's avatar
        Mule
        New Member
        9 years ago

        v-sihou-msft

         

        The last time I used this was about 2 weeks ago at which time it was possible to choose which column to sort by, by clicking on the ... at the top-right of the gantt visualisation, but this option no longer appears:

         

         

        So it seems that something has changed; is there a team at Power BI or GitHub or somewhere else that could advise if/when the functionality will return?

         

        Thanks,