Forum Discussion
24 hour based gantt
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 c...
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
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.