I am pretty new to Powerpivot and therefore not sure how crazy of a request this is, but here goes.
On the attached spreadsheet on the Oil 7 Day Avg tab there is a pivot table and chart created using powerpivot. I need to remove all blank (zero production) data from this chart. The reason there is zero production data is because I have "Days" in the in the row label currently. I think this is what I need to replace with a new calculated measure but I am not sure how to do it or if that would fix it.
I want to remove all the blank production from each category and have the row labels 0 to the nth row.
The goal is to smooth out the chart. It is supposed to be non zero production(y) vs the number of days there was non-zero production(x) for each category.
Is this possible?
Bookmarks