Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
Sunila
Helper I
Helper I

Actual Vs Budget Numbers does not align on applying date filter

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.

Sunila_0-1693493079696.png

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_1-1693493669428.png

 

 

4 REPLIES 4
Sunila
Helper I
Helper I

@technolog 

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

@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
Super User
Super User

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
Super User
Super User

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

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





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!






Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.