Microsoft Gantt chartt 2.2.3 Sorting Issue

[Anonymous]

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. 

Project	Phase	Start	End
A	Requirement	8/1/2022	8/12/2022
A	Development	8/12/2022	8/22/2022
A	SIT	8/22/2022	9/9/2022
A	UAT	9/14/2022	9/27/2022
B	Requirement	8/28/2022	9/1/2022
B	Development	9/5/2022	9/30/2022
B	SIT	9/30/2022	10/14/2022
B	UAT	10/17/2022	10/28/2022
C	Requirement	5/5/2022	5/20/2022
C	Development	5/23/2022	6/10/2022
C	SIT	6/13/2022	6/24/2022
C	UAT	6/27/2022	7/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.

[Ashish_Mathur]

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.