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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Not applicable

Burnup Chart to compare hours spent and committed hours for project

Hi guys, 


I'm working on creating a burnup chart of sorts in Power BI, and am trying to compare a team's cumulative hours (based on timesheet submissions) with their no. of committed hours to the project over PI2 (period of seven weeks). I've already created a new measure that calculates cumulative hours spent by each team, but have no idea how to create an accumulating linear trend line that pro ratas their committed hours over X time period (e.g. % of committed hours reached / exceeded at a certain point in time).



The source data is sorted per single entry: username / project name / task name / hours spent on project today / department name. I then created a "PI2 Commitment" conditional column to input committed hours (If team name is X, committed hours is 55).


user submit hours.JPGpi2 commitment.JPG

cumulative hours filters.JPGcumulative hours.JPG

Final goal:



Already tried:

In-built trend line doesn't fit this purpose, as it creates a trend based on the diagram, rather than tracking committed hours over PI based on source data.


I'm a complete newbie to power bi, so any help would be appreciated! Thanks

Community Support
Community Support

@Anonymous ,


So can I understand that in the trend line you want to add a few conditions(e.g.: The "PI" or other X-axis, legend values) based on the data in your source?


If so, actually the built-in trend line may not meet your requirement because it's too naive. As suggestion, have you tried any Custom visual or Python/R visual?


Community Support Team _ Jimmy Tao

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

Not applicable

@v-yuta-msft the orange linear line should be the original, total time committed by the team at the start of the sprint e.g. 55 hours. Based on whiteboard diagram, The black line records the cumulative hours the team has recorded to date e.g. 22 hours. In the future, if the team exceeds the 55 hour estimation and instead spends 75 hours on the project, the black line will rise above the orange linear line 


Example from another website - the red line has risen above the blue linear line (committed points) because they are making good progress:



Helpful resources

Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.