Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Microsoft Gantt chartt 2.2.3 Sorting Issue

Hi, 

I have the data in the following table and was trying to use the Microsoft Gantt chart in Power BI. The bars are rendering fine but not according to the specified order in the phase column.  The bars are rendering according to Alphabetical order in Phase column.

 

I have assigned parent with Project and Task with Phase as in the below table. 

ProjectPhaseStartEnd
ARequirement8/1/20228/12/2022
ADevelopment8/12/20228/22/2022
ASIT8/22/20229/9/2022
AUAT9/14/20229/27/2022
BRequirement8/28/20229/1/2022
BDevelopment9/5/20229/30/2022
BSIT9/30/202210/14/2022
BUAT10/17/202210/28/2022
CRequirement5/5/20225/20/2022
CDevelopment5/23/20226/10/2022
CSIT6/13/20226/24/2022
CUAT6/27/20227/29/2022

 

I am a newbie and wanted to know how I can represent the chart correctly with the following order as per in the above table according to Phase column.

Need Help

1 Reply

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    3 years ago

    Hi,

    Create a Table similar to the one below

    Phase Order
    Requirement 1
    Development 3
    SIT 2
    UAT 4

    Change the numbers in the Order column to your chosen order.  Sort the Phase column by the Order column.  Create a relationship (Many to One and Single) from the Phase column of your Data Table to the Phase column of this new table.  To your visuals, drag the Pahse column from the new table.

    Hope this helps.