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