How to spread value over period of time

[MattiasFly]

Good day,

I have a PowerBi report conncected to a Microsoft project (custom entreprise template) and I would like to visualise ressources utilization over time.

For this in the "Tasks" table I have the following fields:

• DateTaskStart
• DateTaskFinish
• Taskduration
• TaskWork
• RessourceName

Right now I'm using a Line Chart with DateTaskStart in Axis, RessourceName in Legend and TaskWork in Values. A Matrix would also be fine.

The problems are:

• The work is not spread over the TaskDuration
• The line chart visual goes straight from data point to data point without reseting to 0 when there is no work.

I think that I need to generate a calendar table, spread the Work over the TaskDuration and put 0 when there is no work.

Project must already be doing this in order to generate this kind of Matrix (here at the week drill level):

I'm not good enough at PBI yet to manage that operation. Can you please help me, or lead me in the right direction?

Thank you.

[v-yuta-msft · Accepted solution]

@MattiasFly ,

You may create a calculate column to replace "" with 0 so in line chart the point will be direct to 0, not the next value. 

TaskDuration New =
IF ( Tasks[TaskDuration] = "", 0, Tasks[TaskDuration] )

In addtion, if it still can't meet your requirement, please share more specific details about your requirement, and also share some sample data if possible.

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.