24 hour based gantt

[Anonymous]

HI, 

I have table with tasks done by staff, and each task has field Start_Date_Time and Close_Date_Time. As all tasks last just few hours and finish same day, I would like to display that in gantt chart but with hours on duration axis. Advice please how to do this. Thanks 

[MichMatt]

I know it's been a few years since this question was posed and answered but I am having the same problems and came across this post. I found a visual in AppSource called as Timeline that allows you to create a Gnatt chart with hours/mins.

[v-haibl-msft]

@Anonymous

There is no Hour type for current version of Gantt visual. Please vote this idea here to make it possible in future version.

Best Regards,

Herbert

[Anonymous · Accepted solution]

Thanks for your quick answer, 

As there is no visual for hour based gantt, I created matrix with additional columns for hour based status.  Formula example is 08 = IF(AND(HOUR(SCHEDUAL_TBL[START])<=8;HOUR(SCHEDUAL_TBL[CLOSE])>8);1;BLANK())

It would be interesting if Measure could be created with hours column headers, and having same result as one using new columns, and we can always use R solution http://community.powerbi.com/t5/R-Script-Showcase/Schedule-view/m-p/69026/thread-id/43

[v-haibl-msft]

Creating matrix seems to be a good alternative. 

Best Regards,

Herbert