Filtering Contracts based on expiring Period by months

Hi vtech007, have you tried to create a calculated column and then use it as a filter? 

Expires In = 
VAR CurrentDate = TODAY()
VAR Expiration_Date = YourTable[Contract_End_Date]
VAR MonthsDiff = DATEDIFF(CurrentDate, Contract_End_Date, MONTH)

RETURN
    SWITCH(
        TRUE(),
        MonthsDiff <= 3, "Expires in the next 3 months",
        MonthsDiff <= 6, "Expires in the next 6 months",
        MonthsDiff <= 12, "Expires in the next 12 months"
        )

You can then activate the select all option from your slicer

If it helped you please mark it as solution