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...
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

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi! i also tried that but Power BI only limits itself to showing the data of only 1 day which is the present and i need to also show the info of past days within the present month, for example, now we are in may 10, so i need to show the info of may 10 and also 9,8,7,5... and all the way back to day 1, and repeat this with every month, working with 1 month i'll be okay

    • Anonymous's avatar
      Anonymous
      Not applicable
      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