I’m currently working on a financial reporting dashboard. We use a weekly 4-4-5 reporting calendar so can’t use the standard time intelligence functions. I’ve got a comprehensive dates table including indexes for Year/Period/Week.
My report page has a slicer to select the Year & Week (single field in the dates table) which drives the visual elements displayed on the page, such as tables and cards showing current week and period to date performance.
The problem I’m having is that I want to show an additional chart with a rolling 13-week trend for various measures (i.e. based on the Year/Week selected using the slicer, the chart needs to shows the range of 13 weeks from current selected week to -13 weeks).
Everything I’ve tried only shows up as a single week on the chart because the slicer is controlling the week for the whole page. We’ve had consultants in who have tried various dax formulas but nothing seems to be working. So far, we’ve only been able to calculate the total 13-week value for each measure, but when plotted it just displays as a single weekly value.
Does anyone have any ideas how to go about showing multiple weeks on the chart?