Forum Discussion
Create a time series graph from a task table
I'm trying to figure out how to use Power BI to create a graph of worker task encumbrance from a table so that my organization can monitor and assess our total task commitments over a period of time. We regularly send teams out on the road for various amounts of time, and need to monitor our commitments into the future.
Each task is recorded in a table with Start and End dates, and the number of workers required (among vaious other data).
| Task List | Start Date | End Date | # of Pers Required |
| Task 1 | 1-Jul-24 | 18-Jul-24 | 1 |
| Task 2 | 24-Jan-24 | 31-Jul-24 | 5 |
| Task 3 | 1-May-24 | 1-Sep-24 | 1 |
| Task 4 | 24-May-24 | 30-Nov-24 | 4 |
| Task 5 | 24-May-24 | 30-Nov-24 | 8 |
| Task 6 | 24-May-24 | 30-Nov-24 | 15 |
| Task 7 | 16-Jun-24 | 31-Jan-25 | 9 |
| Task 8 | 19-Jul-24 | 22-Aug-24 | 2 |
| Task 9 | 16-Aug-24 | 18-Sep-24 | 3 |
| Task 10 | 06-Jul-24 | 31-Jan-25 | 2 |
| Task 11 | 08-Jul-24 | 31-Jan-25 | 2 |
| Task 12 | 15-Jul-24 | 15-Dec-24 | 1 |
| Task 13 | 24-Jul-24 | 31-Jan-25 | 2 |
I somehow need to translate this into a graph that will show total workers on any given day, such as in the red line below.
While the table above only shows 13 tasks, my spreadsheet tracks over 100 tasks up to a year in advance and uses 2 different tables that vary only in the type of work to be performed.
Any idea how I can do this?
Hi Nobdyspecial ,
In Power BI, the X and Y axes need to be definite columns of values, so I think you can create a new column.
I create a calculated column and here is the DAX code.
Column = DATEDIFF('Table'[Start Date],'Table'[End Date ],DAY)Then you can get what you want.
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
6 Replies
Hi Nobdyspecial can you give us an example of what you expected and what you have using power bi ?
I'm trying to re-create that graph as we did than manually. Trying to total the # of people column for any given day given the temporary nature of the tasks and then present the data for our Director, I'm brand new to PBI. My boss recommended I try it rather than doing this manually.
So you need a barchart with a color for each task ? or you need to summarize the number of task for each day ? or something else ?
Hi Nobdyspecial ,
In Power BI, the X and Y axes need to be definite columns of values, so I think you can create a new column.
I create a calculated column and here is the DAX code.
Column = DATEDIFF('Table'[Start Date],'Table'[End Date ],DAY)Then you can get what you want.
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
