Show next period in table when using a slicer
What I'm trying to achieve. User selects a period from a slicer. I want a table (visual) to show the actions due in the selected period. I want a another table (visual) to show the actions due in the next period. I want a third table (visual) to show the actions due the period after next. My model looks like this The ABP table is as below (RSPDuePeriod and DueIndex are both merged from the DimDate & DimPeriod Tables in power query) DimDate is a date table with each date assigned to the relevant period DimPeriod is a summary of DimDate but with just the periods so I can index each period for the next period etc I've tried SELECTEDVALUE(DimPeriod[Index]) +1 or +2 to get the relevant index but I can't then work out how to make this filter the information in the ABPDeliverables table? or if this is even the right approach I've tried creating a table using SELECTEDVALUE but it appears the tables don't refresh for the value in a slicer. Any help much appreciated - if I need to tweak the model or date tables I can but this feels like it's simple I just can't seem to make it work. Desired outcome. Select RS_YEARPERIOD 2401 (which equates to index 2) Visual 1 shows rows from ABPDeliverables which have an RSPDuePeriod of 2401 (Index 2) Visual 2 shows rows from ABPDeliverables which have an RSPDuePeriod of 2402 (Index 3) Visual 3 shows rows from ABPDeliverables which have an RSPDuePeriod of 2403 (Index 4) I will then want to add in a calculated measure to show a RAG status to each deliverables based on whether the due date is overdue or with X days from today - but that is secondary to showing the three tables.
