Forum Discussion
Problem regarding cumulative budget using slicer
Thank you for your response, but it doesn't cuite answer my question.
Luckily i managed to work around the issue by adding some parameters in the query.
Issue is solved.
Community ChampionMost people would know how to fix this in Excel. In fact if you switch the line chart to a matrix, you would probably immediately know what to do. Just wrap the formula in an if statement. Check if here are sales this year, and only show the cumulative total if there are (or what ever it is you are trying to do). It can be a bit more challenging if you data is loaded daily. In that case you need a different approach.
Thank you for your response, but it doesn't cuite answer my question.
Luckily i managed to work around the issue by adding some parameters in the query.
Issue is solved.