Dynamic Slicer

Hi ,

Did you try approach1 ? if it doesn't work i will create a full working example and send it over to you.

Approach 1 :

Create a 'Current Month' column in your Date table ( if you don't have one , i would suggest to make a habit of using Date dim, very helpful).

Current Month =  if(
                                 Year('Date'[Date]) = Year(TODAY()) && MONTH('Date'[Date]) = MONTH(TODAY())

                                ,0

                               ,BLANK()
                               )

and  use this field as Visual level filter - Filter Type= Advanced Filtering

Show item when value = is

and enter 0 in the value ----apply filter.

use this as per your requirement at visual or page level.

Thanks,

Bob