This should be relatively simple for some of you, but not for IcyBricks. I cannot alter the data or data table, yet I want the pivot that comes out of Power Pivot to have an x-axis of consecutive dates, so that the resulting chart graphs a linear line. See the simplified example. How do you get 8/4/2015 to show up as a row with a value of zero? Again, I cannot alter the data table.
Bookmarks