Actual Vs Budget Numbers does not align on applying date filter

[Sunila]

I am seeking assistance with an Income Statement report I am currently working on.

This report involves a comparison between actual and budget figures, complete with a variance column. The calculations for both actual and budget numbers are based on the Main Account category, as evidenced in the attached screenshot. Additionally, the report offers filtering options, specifically for date, year, and legal entity.

However, I have encountered an issue pertaining to the Date filtering options. Currently, when I select a Date and year filter (as depicted in the provided screenshot), the changes are only reflected in the Actual figures. This discrepancy arises because these filters draw from the actual date and year values found in the actual table.

On the other hand, the Budget Date and Budget Year columns in the Budget table are utilized for their respective budget figures within the specified year. Consequently, I am in need of assistance regarding the implementation of date and year filters. I aim for these filters, upon selection, to appropriately display the actual and budget columns in their respective designated columns. Your guidance in resolving this matter would be greatly appreciated.

Note : I have had an issue with a LE filter also intially which I resolved by using Slicer table as shown in the screen show. Date filter may need a calendar slicer to pick up dates and year from both tables possibly. 

[Sunila]

@technolog 

I have been able to resolve this issue. Please close or archive this ticket.

[technolog]

@Sunila please share with us how you solved the problem? Did you take advice from @some_bih or did you solve it in some other way?

[technolog]

I hope this message finds you well. I've noticed that this solution remain unresolved. If any of you have managed to find a resolution to the issue, I kindly request that you share your solution for the benefit of the entire community. Alternatively, if you're still facing challenges, please do let us know as well.

Your insights and updates will greatly assist others who might be encountering the same challenge.

[some_bih]

Hi @Sunila please watch video to get idea for your issue and maybe possible solutions.

https://www.sqlbi.com/tv/budgeting-with-power-bi/