https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Line-Graph-with-Sales-and-Forecast/m-p/3811863#M149071 <P>Hi, I am new to the Power BI.&nbsp; 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!</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P> Thu, 04 Apr 2024 19:29:42 GMT Dimps 2024-04-04T19:29:42Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Line-Graph-with-Sales-and-Forecast/m-p/3811863#M149071 <P>Hi, I am new to the Power BI.&nbsp; 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!</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P> Thu, 04 Apr 2024 19:29:42 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Line-Graph-with-Sales-and-Forecast/m-p/3811863#M149071 Dimps 2024-04-04T19:29:42Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Line-Graph-with-Sales-and-Forecast/m-p/3812068#M149091 <P>Add a fake actuals value that matches the first forecast value.</P> Thu, 04 Apr 2024 22:25:29 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Line-Graph-with-Sales-and-Forecast/m-p/3812068#M149091 lbendlin 2024-04-04T22:25:29Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Line-Graph-with-Sales-and-Forecast/m-p/3813054#M149127 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="322401" data-lia-user-login="Dimps" class="lia-mention lia-mention-user">Dimps</a>&nbsp; yup, that should work</P> Fri, 05 Apr 2024 09:28:25 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Line-Graph-with-Sales-and-Forecast/m-p/3813054#M149127 johnbasha33 2024-04-05T09:28:25Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Line-Graph-with-Sales-and-Forecast/m-p/3813996#M149164 <P>Thank you!</P> Fri, 05 Apr 2024 15:24:39 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Line-Graph-with-Sales-and-Forecast/m-p/3813996#M149164 Dimps 2024-04-05T15:24:39Z