Slicer Issues

[tonyb1986]

I have a multi-page report with a slicer on the first 'title' page if you will, this slicer selects the calendar week number.

I have managed to get this filter to sync across 2 of the other pages and they work as expected and as I need them to.

the issue I am having is:

on 4 of the pages, there is a combination of line and column charts, if I get the slicer to select this week's number, then only the data for that week is displayed but I need it to be shown for ALL of the weeks previous. 

the filter is by calendar week but the graphs are in financial (fiscal) week.

is this even possible to do?Screen with SlicerData i want to filter upto the selected week but include the previous weeksData i want to filter upto the selected week but include the previous weeks

[DataInsights]

@tonyb1986,

The article below explains a technique for achieving this. The DAX portion of the solution can be implemented in a measure if you prefer not to use a calculation group.

https://www.sqlbi.com/articles/show-previous-6-months-of-data-from-single-slicer-selection/