Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
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!
Solved! Go to Solution.
Add a fake actuals value that matches the first forecast value.
Thank you!
Add a fake actuals value that matches the first forecast value.
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the September 2025 Power BI update to learn about new features.