Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    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's avatar
v-haibl-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

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's avatar
Anonymous
Not applicable
9 years ago

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's avatar
    v-haibl-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Creating matrix seems to be a good alternative. :smileyhappy:

     

    Best Regards,

    Herbert