Combining Actuals and Forecasts in one continuous Line in Power BI

In several businesses, we have the Actual Sales and Forecasts. We can add these numbers to one line chart and see two lines. But one of my clients asked me if he can have one continuous line with the Actuals until the selected month and the Forecast for all months afterward. Here is how I did it.

Salvatore Cagliari
Towards Data Science
11 min readAug 12, 2023

--

--

--

Nerd passionate about technology, and space science and interested in many other things. On the Business side, an expert in Data Analytics and Power BI.