Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Nobdyspecial
New Member

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 DateEnd Date  # of Pers Required
    
Task 11-Jul-2418-Jul-24  1
Task 224-Jan-2431-Jul-245
Task 31-May-241-Sep-241
Task 424-May-2430-Nov-244
Task 524-May-2430-Nov-248
Task 624-May-2430-Nov-2415
Task 716-Jun-2431-Jan-259
Task 819-Jul-2422-Aug-242
Task 916-Aug-2418-Sep-243
Task 1006-Jul-2431-Jan-252
Task 1108-Jul-2431-Jan-252
Task 1215-Jul-2415-Dec-241
Task 1324-Jul-2431-Jan-252

 

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.

Nobdyspecial_0-1720120321017.png

 

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?

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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)

vyilongmsft_0-1721713458497.png

Then you can get what you want.

vyilongmsft_1-1721713509469.png

vyilongmsft_2-1721713532217.png

 

 

 

 

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.

View solution in original post

6 REPLIES 6
Anonymous
Not applicable

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)

vyilongmsft_0-1721713458497.png

Then you can get what you want.

vyilongmsft_1-1721713509469.png

vyilongmsft_2-1721713532217.png

 

 

 

 

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.

freginier
Super User
Super User

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 ? 

Need to get the total number of people employed on all tasks per day and plot that on a graph that will span over a year. The problem is how do I convert the Start/End date columns to add up the total employed on any given day.

 

You need to create a continuous value, you can't use start and end. 

So you need to create a list of date for each task try do it using power query in power bi

 

Then you will add this new date column on X, number of employee on Y and Task List on legend ! 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.