Req help to add the future Backorder values to the line and stacked column chart

[Invisibleman]

Dear all,

I have a problem and don't seem to get it to fixed. In the power BI, I have a Line and stacked column chart. Which is completely based on this year (2023). There I have the revenue being accumulating, so in February january is being added up, March has then January, February and March, and so on.

Now for the backorders, I want those to show on the correct month of when they are being actualy sold (ETD Date)and not accumulating. But when the month is over, those previous backorders will then need to be added up to the current month. As of now I only seem to get the actual backorder to the current month, but not to the future. This, I think, is due there are no sales yet done in the future.

But how can I make it like so that the revenue is being accumulating, so you can compare with the budget planning and the backorder value adding up to there, but then based on the actual selling month (ETD Date)?

This is what I have sofar All 3 other charts, can be selecting the years too, but the Line and stacked column chart can only select the month.

Here also my Power BI and the excel file for the BackOrder, where I also added the info in how I need the BO to be calculated.

Power BI File Excel file 

Here somewhat short details of how I would need the Backorders value to be calculated.

Thanks in advance for the help,

Regards,

Hans

[Invisibleman]

Problem is solved. I have removed the year and used only the month for the chart. And the in the measure, did make sure to only get the values for the year. But with the year, the chart stopped at the last sales data.