Forum Discussion

Nobdyspecial's avatar
Nobdyspecial
New Member
2 years ago
Solved

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....
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

freginier's avatar
freginier
Solution Sage
2 years ago

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 ? 

Nobdyspecial's avatar
Nobdyspecial
New Member
2 years ago

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.

 

  • freginier's avatar
    freginier
    Solution Sage
    2 years ago

    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 !