I have a chart showing year over year measures, and i want the Date range filter to affect the month and day for both years. I have this all working fine until it gets to the point where the fiscal year laps the calendar year. The FY is Dec1 - Nov 30.
I can make the charts show Jan 1 - Mar 1 for 2018 and 2019, but if i want to show Dec 1 (beginning of fiscal year) thru Feb 1, I only get Jan 1 - Feb 1 because the date selector is looking for Dec 2019. I've attached a workbook set up the same way using sample data, and below are some screen shots. Bottom line is there seems to be no way to show December data if the filter is anything but cleared.
Filter cleared, good, Dec is first:
Jan-March dates selected, good:
Dec - Sept selected, wrong - December is missing:
Hi Ashley,
Range of dates filters don't appear to respect fiscal years. I would recommend submitting an idea:Ideas
