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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
ShaneNewPBi
New Member

Help with separate filter calendar

First time posting so apologies if this has already been covered.

 

I am trying to create a visual that will allow me to show expenses for budget, actuals forecast for each month of the fiscal calendar year selected. I have a matrix visual bringing back what I need however I need the graph to show every month.

I have found this DAX on youtube that brings back the last 6 months, however I want to amend this so it shows from April (first month of my fiscal year ) no matter what month is selected.

Any help would be appreciated - code I have is below:

ShaneNewPBi_0-1702646958702.png

 

1 ACCEPTED SOLUTION
ShaneNewPBi
New Member

I have managed to solve my own problem - simply replaced the "-6" with the variable "ReferenceDate" which makes the 1st month in the visual always show as April (being the 1st month of the fiscal year

View solution in original post

1 REPLY 1
ShaneNewPBi
New Member

I have managed to solve my own problem - simply replaced the "-6" with the variable "ReferenceDate" which makes the 1st month in the visual always show as April (being the 1st month of the fiscal year

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.