How to fix Actual vs Budget - amounts not pulling through in a matrix when there is no budget

Question

Hello Power BI  Champions,

 A colleague from work faces this challenge described below in one of his Power BI reports. I'll appreciate every support:  

"I have a direct connection to a data source where I have built an Actual vs Budget comparison and the issue I have is that when there is no budget against a particular cost center, the value for Actuals drops off the table - see below where the table only shows Actual vs Budget for October but drops off Actuals for November and December:

 

 When I compare Actual vs Actual, you will see that the values for November and December Actuals come through when they were missing against the above comparison vs Budget as there was no budget for November and December for this cost center yet there was actual spend in those months.

I have tried things like replacing blanks in the Budget scenario with zeroes or even a value of 1 for example and that doesn't seem to work. 

Any help would be highly appreciated.

 

 

Additional Context

I've managed to find out how the data is stored in the server and it looks like there is no value for the Budget scenario for the month of Decmber 2023. When comparing Actual vs Budget using a slicer to select the Budget scenario, PowerBI drops the Actuals for the month of December 2023 as there is no budget comparative.

If I was to share a view of how the data looks like, it would be as follows:

Cost CenterMonthScenarioAmountCost CenterMonthScenarioAmount123452023-10Actual-104.00123452023-10Budget122,852.00123452023-10Forecast122,852.00123452023-11Actual7,009.00123452023-11Forecast10,000.00123452023-12Actual101,315.00Based on the above dataset, PowerBI only shows Actual vs Budget for the month of October which is the only month which has values against both the Actual and Budget scenarios. The rest of the months are being dropped off from the matrix visual.

 

Hope this provides some additional context."

 

 

I understand this is a classic Power BI issue with handling missing values on a report, but I've tried using DAX measures functions to replace missing values with 1 or 0. This doesn't work. Please help. Thank you