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.  Th...
Need Help
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.