I have the timeline slicer implemented with below settings.
a) trying to show Fiscal Year (July to Jun) b) Sunday being the first day of the week
I needed to show Fiscal years on the slicer and not calendar year (supposed I select Aug 2015, needs to show as Aug FY16).
Hence, I added another column using the below DAX and used that for Timeline slicer which would be the exact date after one year. (also as stated here)
TimeLine Slicer Date = DATE ( YEAR ( DateCalendar[Date] )+1, MONTH ( DateCalendar[Date] ), DAY ( DateCalendar[Date] ))
This works fine at the Yearly/monthly level but unfortunately, not at weekly level. When I select a particular week say W28 of FY16, the days are not being selected correctly : In some cases it selects “Sun to Sat” in some cases “Sat to Fri” (based on the year).
Could you please advise how I can show fiscal dates on the slicer and make it work correctly at all the levels for all FYs. (Attaching the pbix file for reference) Thank You, Harish
Has this issue been resolved? My visual is displaying incorrect year values, I have set up the Fiscal Year start month as October and Day as 1. The year value is not adjusting properly between 2018 and 2019. The fiscal year should reflect the value of 2019.