Excel non-continuous data points (Power Pivot)

Question

I have a pivot table with some data points like this:

To display a line graph i need y-values for every point, so i formatted the table to insert 0 in every cell with no value, which gives me this:

What i need is a way for the pivot table to just use the most recent y-value when ever it's missing a value. I've simulated this manually like this:

Is there a way to do this with pivot tables?

Answer 1

It's nothing fancy, but I believe a calculated column is a good solution for this. Here's one example: