Forum Discussion
Dimps
2 years agoFrequent Visitor
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.
3 Replies
- lbendlin
Super User
Add a fake actuals value that matches the first forecast value.
- johnbasha33
Super User
Dimps yup, that should work
- DimpsFrequent Visitor
Thank you!