Home Artificial Intelligence Combining Actuals and Forecasts in a single continuous Line in Power BI Introduction Approach

Combining Actuals and Forecasts in a single continuous Line in Power BI Introduction Approach

0
Combining Actuals and Forecasts in a single continuous Line in Power BI
Introduction
Approach

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.

Towards Data Science
Photo by Carlos Muza on Unsplash

To set the context, let’s take a look at the next picture:

Actuals and Forecast with a line chart (Figure by the Author)
Figure 1 — Actuals and Forecast with a line chart (Figure by the Creator)

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:

Target view requested by my client (Figure by the Author)
Figure 2 — Goal view requested by my client (Figure by the Creator)

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:

LEAVE A REPLY

Please enter your comment!
Please enter your name here