Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a typical spreadsheet with dates as the top row, then the first column is the employee name, second column is a task they worked on, then the remaining columns are the number of hours they worked for a corresponding date. I need the dates to be a column as well is there a way to do this? I thought I had done this before in Power BI but I cannot figure it out or find a similar posting about this issue.
Solved! Go to Solution.
HI @dbragdon314
Edit the table in Power Query, and from memory, select the first two columns (Employee Name and Task) and use the "Unpivot other columns" option from the modelling tab
HI @dbragdon314
Edit the table in Power Query, and from memory, select the first two columns (Employee Name and Task) and use the "Unpivot other columns" option from the modelling tab
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |