Forum Discussion

EnrichedUser's avatar
EnrichedUser
Icon for Helper III rankHelper III
5 years ago

24 Hour Gannt Chart Matrix

Hi All,    I am looking to make a visual the show when each person did a certain task.    I have two tables. The first is [ActivitySheet] ActivitySheetDate UserID StartTime2 EndTime2 Tran...
Need Help
EnrichedUser's avatar
EnrichedUser
Icon for Helper III rankHelper III
5 years ago

v-jingzhang Thanks for taking a look. I went through your file and saw the working time column you added in power query and see how it works. I dont think it will work well for my application since that activity sheet has upwards on 1mm rows as is. 

v-jingzhang's avatar
v-jingzhang
Icon for Community Support rankCommunity Support
5 years ago

EnrichedUser I know it's not perfect as it brings too much data into the table and adds a lot of rows. There may be some measure could deal with it. I will try to work it out but I'm not sure if I'm able to.