How much percentage of time spent on individual project in azure DeVops using power bi report

[hariram2]

Hi Team,

I have a task like 1 employee is working on multiple projects.we have created different projects in azure devops.By using power bi i should create a Pie chart .

How much persentage ofhours they spent on individual project in azure devops.

Also my manager need to see data current sprint wise.

In azure devops having field like 1.Original Estimate  2.Remaining work  3.Completed work. 4.Iteration start dat  5.Iteration end date 6.Iteration  7.Project name  8.Workitems

Please anyone.It is a Urgent task to complete. Please find below image for reference.

[v-chenwuz-msft]

Hi @hariram2 ,

1 Get data from Azure DevOps to Power BI. I recommand you use Azure DevOps rest API.

Get started with the REST APIs for Azure DevOps Services and Team Foundation Server - Azure DevOps S...

2 Add a calcualte column in the table via some codes like the below.

duration = datediff( [Iteration start date]  ,[Iteration end date], minute)

3 Create pie chart and put the project name and duration in it.

How to Create a Pie Chart in Power BI? (with Example) (wallstreetmojo.com)

Best Regards

Community Support Team _ chenwu zhu

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

[hariram2]

Hi Team,

I am attached sample data.

Here main concept is example:1 employee is working for 3 projects.

We want to know employee how much of percentage they worked on each project.

Having slicer weekly and monthly.

Plz help here.