cancel
Showing results for
Did you mean:
Frequent Visitor

Trending average of completed sprints

I have a simple calculated column that returns the percentage of sprint commits vs sprint completions. I can show that as a line on a chart just fine. What I'd like to do is show how that average is trending. For instance, if we completed 68% in Sprint 1, 90.2% in Sprint 2, and 83.7% in Sprint 3 I'd like to see it start at 68% then show the average over time between 1 and 2, then the average over 1,2 and 3.

1 ACCEPTED SOLUTION
Solution Specialist

@snoh8r49 ,
try this measure:

percentage = selectedvalue('TableName'[PercentColumn]).

Use this measure in a chart with sprint column on the axis and this measure as the value.

Essentially you don't want to summarize the percent.

Even if you just select the column and change the column property to "Don't Summarize" and plot this value, it should resolve the question. Let me know.

Appreciate a thumbs up if this is helpful.

Did I answer your question? Mark my post as a solution, this will help others!
If my response(s) assisted you in any way, don't forget to drop me a Kudos 🙂
Kind Regards,
Avinash
Solution Specialist

@snoh8r49 ,
try this measure:

percentage = selectedvalue('TableName'[PercentColumn]).

Use this measure in a chart with sprint column on the axis and this measure as the value.

Essentially you don't want to summarize the percent.

Even if you just select the column and change the column property to "Don't Summarize" and plot this value, it should resolve the question. Let me know.

Appreciate a thumbs up if this is helpful.

Did I answer your question? Mark my post as a solution, this will help others!
If my response(s) assisted you in any way, don't forget to drop me a Kudos 🙂
Kind Regards,
Avinash

Announcements

Join Arun Ulag at MPPC23

Get a sneak peek into this year's Power Platform Conference Keynote.

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors
Top Kudoed Authors