Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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.






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) (


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.




Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors