In several businesses, we’ve got the Actual Sales and Forecasts. We will add these numbers to 1 line chart and see two lines. But one in all my clients asked me if he can have one continuous line with the Actuals until the chosen month and the Forecast for all months afterward. Here is how I did it.
To set the context, let’s have a look at the next picture:
For this chart, I just entered a number of numbers in Excel and created a line chart from these numbers.
You may see that the Actual and Forecast Sales lines are diverging from one another, which can be as expected.
While that is OK generally, my client desired to have a distinct view of his data:
As you may see, the goal is to create one continuous line. Starting with January, then going forward with the Actual numbers per Month until the chosen Month (Set in a separate Slicer). Then proceed with the Forecast numbers. However the cutover at the chosen month have to be connected to form one continuous line.
Furthermore, the cutover point must move to the chosen month when he modifies the choice for the month.
Well, that sounded interesting.
At first, the request sounded familiar: I need to pick a particular month, and I need to see the info for the whole 12 months and use the chosen month to do a selected calculation.
I explained an answer to this in one in all my past articles: