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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare 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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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

Top Kudoed Authors