How to create a rolling 4 month/period graph using slicer?

[spraff]

I have multiple graphs connected to a slicer which I have one week selected; however, I have two graphs which require multiple weeks worth of data (both images inserted below). Ideally, I'd like to select one week, and then have the two graphs populate with that week AND the prior 2 & 3 weeks respectively. But how?

 

[Ozeroth]

One way of doing it:
1. Create disconnected 'week selection' table to select the latest week to display, and add as a slicer, with a [Week Selected] measure to harvest the week selected.
2. Create an [Alarm events last k weeks] measure that does a SUMX of [Alarm events] over your normal weeks dimension, but only if the week is in the required range (and defaults to blank otherwise). Then only the weeks with a non-blank measure will show up on the chart.

e.g. for current week and the two previous weeks

[Alarm events current and prev 2 weeks] =
SUMX (
    VALUES ( Weeks[Week] ),
    IF (
        Weeks[Week] <= [Week Selected]
            && Weeks[Week] >= [Week Selected] - 2,
        [Events Total]
    )
)

And actually your other charts (that only need to display one week) could drive off the same [Week Selected] slicer, with a similar measure with the condition changed to Weeks[Week] = [Week selected].

 

[Ozeroth]

Actually it's probably nicer to write this with FILTER instead of SUMX, but the result is the same:

[Alarm events current and prev 2 weeks] =
CALCULATE (
    [Alarm Events],
    FILTER (
        VALUES ( Weeks[Week] ),
        Weeks[Week] <= [Week Selected]
        && Weeks[Week] >= [Week Selected] - 2
    )
)

 

[spraff]

Ozeroth,
Thanks for your reply! However, I'm afraid I'm too green to follow
Can you please flesh out the formula w/o the argument w/in it?

 

[Ozeroth]

No problem Which part do you need help with exactly? Maybe post your actual tables with some dummy data