Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Date Slicer

Hi there, 

I am new to PBI, i have a date slicer icluding "blank" and 12 months of the year and i want the date slicer to select the current and all previous months by default. Thanks in advance

Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    3 years ago

    Anonymous , As of now you have create a column like this and select and and save on this month , last month

     

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

     

    as per Linkedin update, slicer default feature is in progress

     

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