Need help with the slicer filtering

[Oliya]

https://drive.google.com/file/d/1kFf_Q2wl4FEWnABUJNpIX741SOf78iPP/view?usp=share_link

Ths is the sample file. I have a date slicer and a reference date slicers on the basis of which I am calculating change% compared to reference period.
Suppose I have only data of Jan month for 2022 then in the reference period while comparing it with year 2021 they should only see jan in the year 2021 and not all months in the reference slicer. How I can achieve this?

[Oliya]

Thanks for the solution. But this not working at Qtr level how I can apply the logic as Qtr level?

[Jihwan_Kim]

Hi,

I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

reference date visual filter: =
VAR _selectedyear =
    MAX ( 'Date'[Year] )
VAR _selectedmonth =
    MAX ( 'Date'[MonthNo] )
RETURN
    COUNTROWS (
        FILTER (
            'Reference Date',
            'Reference Date'[Year] = _selectedyear - 1
                && 'Reference Date'[MonthNo] = _selectedmonth
        )
    )