Forum Discussion

SLima's avatar
SLima
Helper I
4 years ago

filter with current date automatic

filter with current date automatic

Need Help

5 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    SLima , You need create a new column like this and filter on page using Today

     

    Date Type = SWITCH(TRUE(),'Date'[Date]=TODAY(),"Today"
    ,'Date'[Date]=TODAY()-1,"Yesterday"
    ,'Date'[Date]&"")

    • SLima's avatar
      SLima
      Helper I
      4 years ago

      I understand, but if I want to filter another date I can't

  • rsbin's avatar
    rsbin
    Community Champion
    4 years ago

    SLima,

    I think this might be what you are looking for.

    Search Youtube for something like:  "How to set a date slicer to TODAY by default in Power BI"

    I tried posting a link, but it didn't take.

     

    Regards,

    • SLima's avatar
      SLima
      Helper I
      4 years ago

      In fact, I need you to bring the current day selected and I also have the possibility to select dates before and after