Forum Discussion
Date Filtering - Fiscal Year
I have the dates aligned to follow the fiscal year, but the data is still showing from last year. July starts our fiscal year, I want the data to populate as we go through the months. So in the photo...
Okay, so you would just need some slight modifications for the year. Try this please..
FYYearNum = VAR FYStartMonth = 7 VAR CurrentYear = Year ( TB_MDH_DATA_DAILY_MONTHLY[DT] ) VAR CurrentMonth = Month ( TB_MDH_DATA_DAILY_MONTHLY[DT] ) VAR PriorYear = CurrentYear - 1 RETURN IF ( CurrentMonth >= FYStartMonth, PriorYear, CurrentYear )
Hello - I believe this is becuase there is not a filter on the year. You can modify the dates included in your visual either by using the filters pane, selecting the relevant date range, or you can create measures for time periods such as current year, prior year, etc.
If I filter by year and select 2022, it shows Jan - July. I would like it to start on July. Do I need to filter the column some how?
In the visual pane, for month, click the drop-down menu and choose show items with no data. Does that work?