Producing project report in power bi based on timesheet data

[studioacosta]

I'm working with the excel timesheet format my boss uses (and does not want to change), so I'm having to figure out how to clean up that data and make it usable. I'm working on generating project reports based on those timesheets.

I want to create a visual report that tracks hours worked per employee (and total) over time for a specific project, as well as to drill down and show that same info per phase. At this point I've figure out how to use Power Query to isolate the specific project data, but I'm stuck as to how to organize the data and create the visual in power bi. I'm including snapshots of the original timesheet that will be filled out by the user, the current status of my data table post power query, and a sketch of what I want my visualization to look like. Where do I go from here? I feel very out of my depth but this forum has been an absolute lifesaver with the amount of help and knowledge available here!