Forum Discussion
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...
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 ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Sie, please respond