usually we use Gantt chart to track the project progress, take the picture blew for example, the dark part means completed, the light part means waiting for being done.
![](https://jie-tao.com/wp-content/uploads/2019/11/5.PNG.jpg)
To reach this result, there are two solutions. The steps in azure devops are same for both solutions.
- Add start date and end date for each tasks. The Admin can change the layout to make these two fields visible on edit page, but I can only change them in backlogs
![](https://jie-tao.com/wp-content/uploads/2019/11/1.png)
- Add Efforts information: estimate time, already done and left hours. The picture blow shows I have done 80% ‘s workload.
![](https://jie-tao.com/wp-content/uploads/2019/11/3.png)
- Create a view for listing all user stories and tasks. ( one time effort for extracting the data)
![](https://jie-tao.com/wp-content/uploads/2019/11/2.png)
- Two solutions:
- Power BI: read directly from azure to get all projects information. ( I will show steps blew)
- Use Microsoft Project to get user stories ( license required) https://www.youtube.com/watch?v=vmQjDJ01iso
Power BI steps:
- Download Gantt plugin. https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380765?tab=Overview
- Install Gantt plugin by click three dots and import.
![](https://jie-tao.com/wp-content/uploads/2019/11/image-2.png)
- Import data through “Get Data- More – Online Service – Azure Devops(beta)”, then choose the view you created in Devops.
- set the Task, start date, end date, % complete for Gantt chat.
Leave a Reply