In several businesses, we now have the Actual Sales and Forecasts. We will add these numbers to at least one line chart and see two lines. But certainly one of 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 take 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’ll be able to see that the Actual and Forecast Sales lines are diverging from one another, which could be as expected.
While that is OK normally, my client desired to have a unique view of his data:
As you’ll be able to 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 alters the choice for the month.
Well, that sounded interesting.
At first, the request sounded familiar: I would like to pick out a particular month, and I would like to see the info for the complete yr and use the chosen month to do a specific calculation.
I explained an answer to this in certainly one of my past articles: