filter not changing based on page level filter

[joshcomputer1]

I have a month slicer pointing to Date[Monthshort] in my Date table. This shows the 3 letter month name.  It is currently showing all 12 months.  I am using a calculated column called "IsLastSixMonths" to determine if the date in Dataset[ContactDate] is in the last six months. This results to True/False and updates dynamically based on today's date.  I have this as a filter on the page visual, and everything else on the page is filtering correctly. How can I get my filter visual to only show the six month window?  

[Anonymous · Accepted solution]

@joshcomputer1,

In your scenario, create the calculated column in the Date table instead of the DataSet table, then drag the calculated column to page level filter, this way, the month slicer will be filtered correctly.

IsLastSixMonth1 = VAR MonthDiff = IF ( 'Date'[Date]<= TODAY (), - DATEDIFF ( 'Date'[Date], TODAY (), MONTH ), DATEDIFF ( TODAY (), 'Date'[Date], MONTH ) ) RETURN IF ( MonthDiff >= -6 && MonthDiff <= -1, TRUE () )  

Regards,
Lydia

[Anonymous]

@joshcomputer1,

I test the scenario as yours and can’t reproduce your issue. I create the calculated column using the DAX below, and put it to page level filter and set its value to True, the month slicer is filtered correctly.

IsLastSixMonths = 
VAR Datediff =
    1
        * ( 'Calendar'[DateKey] - TODAY () )
RETURN
    SWITCH (
        TRUE,
        AND ( Datediff <= 0, Datediff >= -180 ), TRUE(),
        Datediff < 180, FALSE()
    )

Would you please share your PBIX file for us to analyze? You can upload PBIX file to OneDrive, and send me the shared link of the PBIX file via Private message.

Regards,
Lydia