Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Solved! Go to Solution.
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.
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.
Kudos! Team
Please help
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.
@prinuce ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Sie, please respond
Sie, please respond
Sie, please respond
Sie, please respond
Sie, please respond
Sie, please respond
Sie, please respond
Sie, please respond
Sie, please respond
Sie, please respond
Sie, please respond
Sie, please respond
Sie, please respond
Sie, please respond
Sie, please respond