How do I create a pivot table with a simple timesheet table?

studioacosta

New Member
Joined
Jan 17, 2025
Messages
9
Office Version
  1. 365
Platform
  1. Windows
I'm working with an existing timesheet (that I can modify to a slight degree). The end goal is to be able to create project reports in power bi that break down time spent by each employee per phase of the project across time. I've gotten to the point where I've created a power query to clean up the data and trim it down to only the specific project I'm looking at. Now I've got a table with the first column being the date, and each subsequent column showing the different phases, and the cell values populating for time worked (Right now I'm just working with one time sheet for one person).

I think I need this to be a pivot table though, and I can't figure out how to make that happen. If I select the current table and make it a pivot table, "hours worked" is not a field option, and I don't know how to get excel to recognize it as one with the table format that I have. Can anyone help me sort through this mess? Uploading screenshots of: the starting timesheet, the table I've created using power query, and the structure of the visual I'm hoping to arrive at eventually.
 

Attachments

  • Screenshot 2025-01-27 094023.png
    Screenshot 2025-01-27 094023.png
    76.4 KB · Views: 3
  • Screenshot 2025-01-27 094055.png
    Screenshot 2025-01-27 094055.png
    105.5 KB · Views: 3
  • Screenshot 2025-01-27 100848.png
    Screenshot 2025-01-27 100848.png
    77.8 KB · Views: 3

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

Forum statistics

Threads
1,226,017
Messages
6,188,442
Members
453,474
Latest member
th9r

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top