Forum Discussion
Create a time series graph from a task table
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.
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 !