I am using set analysis for one of the first times. I have "sales" for years 2015, 2016, and 2017. I am using =Month([Date]) as the Dimension which appears to work fine. I have data for all of 2015, all of 2016 and through April of 2017. All of this data is displayed correctly.
However, the 2017 line for April then goes on to May, June, July etc. with values of zero. So it makes it appear as if there is data by extending the line. I have no data, no blanks, no information or May - Dec of 2017 but yet the line extends. I would like it to end with the last known value (sum of values).
Here is the analysis that I use for each year with only the "2015" changed.
Is the 'Suppress Zero Value' checked on the presentation tab? If it isn't make sure to check it. Also, if that doesn't work, may be try this for 2017 expression