Issue with Timeline slicer week selection - for Fiscal Year implementation
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
