Forum Discussion
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....
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 ,
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.