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. where the resource is utilized in task and percentage calculation who is free this time and when he will be free.  Please help me 

 


 

 
 
 
 
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.

44 Replies

  • 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.

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    prinuce ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

  • prinuce's avatar
    prinuce
    Helper I
    5 years ago

    Sir i m creating gantt visualization. Please help how to do % of completion of task. we have start date and end date column

    please help me.

      Task list.xlsx