Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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:
Solved! Go to Solution.
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
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
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 7 | |
| 6 | |
| 4 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 25 | |
| 17 | |
| 9 | |
| 8 | |
| 7 |