The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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.
User | Count |
---|---|
15 | |
12 | |
8 | |
7 | |
7 |
User | Count |
---|---|
24 | |
21 | |
12 | |
10 | |
7 |