Forum Discussion

prinuce's avatar
prinuce
Helper I
5 years ago
Solved

task utilization dashboard

Hi Team, Need some help in power bi. Actually i m creating power bi resource dashboard. But need some help. my requirement is to calcuation from today to next upcoming 3 month task. w...
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    5 years ago

    Hi prinuce  ,


    According to your description, I am a little confused. If you want to make a Gantt, you may need to have a %completion
    column and a duration column, so I first added two columns, and then added to the Gantt chart, I hope it will help you:
    Step 1: Add column( %complete)

    % completion = IF('Sheet1 (2)'[Status]="In Progress",0.5,IF('Sheet1 (2)'[Status]="Complete",1,0))

    Add another column:

    Duration = DATEDIFF('Sheet1 (2)'[Start Date],'Sheet1 (2)'[End Date],DAY)

    Step2:Add gantt visual

    The final output is shown below:

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

v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
5 years ago

Hi prinuce  ,


According to your description, I am a little confused. If you want to make a Gantt, you may need to have a %completion
column and a duration column, so I first added two columns, and then added to the Gantt chart, I hope it will help you:
Step 1: Add column( %complete)

% completion = IF('Sheet1 (2)'[Status]="In Progress",0.5,IF('Sheet1 (2)'[Status]="Complete",1,0))

Add another column:

Duration = DATEDIFF('Sheet1 (2)'[Start Date],'Sheet1 (2)'[End Date],DAY)

Step2:Add gantt visual

The final output is shown below:

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

prinuce's avatar
prinuce
Helper I
5 years ago

Kudos! Team