Trending average of completed sprints

[snoh8r49]

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.  

[adudani · Accepted solution]

@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.