Forum Discussion

Dimps's avatar
Dimps
Frequent Visitor
2 years ago
Solved

Line Graph with Sales and Forecast

Hi, I am new to the Power BI.  Need to create a line graph to combine actuals and Forecast data. My dataset has the actuals and forecast in one column and I have the forecast flag where it says "Y" (for the future months) and "N" (for the past months). In the line graph, I see the gap when it is moving from the recent past month to the future month. for example in the below example you see the gap between March 2024 and Apr 2024. How can I avoid this gap? Thank you!

 

 

  • Add a fake actuals value that matches the first forecast value.