Forum Discussion

kivancc94's avatar
kivancc94
Helper I
2 years ago

Filter Detecting and Selecting Current Month by itself

Hi,

I would be appreciated if you could help me to solve this issue. 

What I would like to achieve is "Year and month filter needed to be automatically realize current year and month, and will select year or month filter by itself. We are not gonna select any month. Program must understand today's month and click filter." 

As I know there is no way insert measure into filter.




Is there any way of measure or smt to implement that ?

Thanks in advance. 
Regards

 

Need Help
Show and Tell
Tips and Tricks

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    2 years ago

    kivancc94 , As of now, we can not default based on a measure. You have use a work around

     

     

    Create a column and save that on This month in slicer

    Month Type = Switch( True(),
    eomonth([Date],0) = eomonth(Today(),-1*month(Today())),"Last year Last Month" ,
    eomonth([Date],0) = eomonth(Today(),-1),"Last Month" ,
    eomonth([Date],0)= eomonth(Today(),0),"This Month" ,
    Format([Date],"MMM-YYYY")
    )

     

     

    Default Date Today/ This Month / This Year: https://www.youtube.com/watch?v=hfn05preQYA