Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Automatic current time date filter

Hi people!!

 

I was asked about filtering data by date, i have done that by now, but now another step of difficulty was added to this task, i need the date filter to automatically go to the date we are in currently, is this possible? if it is, how can be done? thanks in advance

Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

     

    I get it.

    Please try this measure.

     

    Measure = 
IF(MAX('Table'[Date])>=EOMONTH(TODAY(),-1)+1&&MAX('Table'[Date])<=TODAY(),1,0)

     

    Drag it into the filter and set the show items when the value is 1.

    The PBIX file is attached for reference.

     

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly -- How to provide sample data

5 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous , based on what I got, You need  column like this ,

     

    and save it on today


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

     

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi! thanks for you answer, i tried to use the date on the filter column on the right, filtered by date and say that belongs to today, however if i click on a graphic i have with info from past dates, all my info goes to 0 why could be happening?

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Hi Anonymous ,

         

        The filter provides this option. Please check if this setting meets your needs.

        Best Regards,
        Gao
        Community Support Team

         

        If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

        How to get your questions answered quickly -- How to provide sample data