Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
hariram2
Helper I
Helper I

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

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.

 

hariram2_0-1661360672751.png

 

 

 

2 REPLIES 2
v-chenwuz-msft
Community Support
Community Support

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.

 

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.

 

hariram2_0-1662119302777.png

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.