Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

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.

1 REPLY 1
Ashish_Mathur
Super User
Super User

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.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.