Forum Discussion

rsbin's avatar
rsbin
Community Champion
5 years ago

Matrix Visual as a Gantt Chart - by Hour

Good Morning,

Edited:  Have edited this message in an attempt to provide additional data and clarity.

I am attempting to create a gantt type chart using the Matrix visual. 

My task is to depict activity (represented by various letters) that happens in a train yard on a daily basis.   Because the activity happens overnight, my "Project" is depicted as the date range, and the hourly timeline is represented as such.

I have mocked up a simplified example in Excel as follows.:

 

 

In Power BI, I have created my Column Headers using a Time Dimension table and the Row Headers from a Fact Table:

ProjectTask(TrainID)DepartureReleaseRoundedTrainLength
7/31 - 8/11999:152:459680
8/1 - 8/21999:152:4510000
8/2 - 8/31999:153:009609
8/3 - 8/41999:151:308500
8/4 - 8/51999:152:009200

 

My Fact table has the Release Time for TrainID 199 = 02:45 for the first record. I would like the "1" (or "R"), to show up in the correct time column.  I am unable to get a Measure that will resolve this.
My fields are TrainStatistics[ReleaseRounded] and Dim_Time_Matrix[HHMM].   And then similarly, for each other activity I need to represent (i.e. D = Departure).

Appreciate any guidance and support from the Community.

 

Thanks and best regards,

2 Replies