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
v-jingzhang's avatar
v-jingzhang
Icon for Community Support rankCommunity Support
5 years ago

Hi EnrichedUser 

I made some transformations to the table in Power Query Editor. You could see specific steps in the attached pbix as well as the measures.

Hope this helps.

Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.

  • 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.