Forum Discussion

admin_xlsior's avatar
admin_xlsior
Post Prodigy
6 years ago
Solved

filter date slicer before today

Hi,

 

Is there a way the date in slicer automatically set Max value with today's date, but I do not want to use "Relative date include today" setting, since I still need the null date (1900/01/01)

 

Thanks,

 

Tutorial Requests
  • jdbuchanan71's avatar
    jdbuchanan71
    6 years ago

    If you add a column to your date table like so

    DateOffset = 
DATEDIFF(TODAY(),'Date'[Date],DAY)

    That will show 0 on today, -1 for yesterday, etc.

    Then you can use this column as a filter on your date slicer and set it to <= 0 OR blank:

    I think that will give you what you are looking for.

7 Replies

  • jdbuchanan71's avatar
    jdbuchanan71
    Super User
    6 years ago

    Hello admin_xlsior 

    I'm assuming you are showing a measure in a visual that has data against the null date?  You can apply that measure to your date slicer as a filter and set it to Is Not Blank which will then only show dates with data in the slicer.  Will that work for you?

    • admin_xlsior's avatar
      admin_xlsior
      Post Prodigy
      6 years ago

      Hi, 

      Actually no, I just want the date slicer always point or fill in with today's date in its Max value (To date)

      But yes, the reason I do not want to use Relative Date because I have data which is Null, so it will be filtered out if I'm using Relatif date. I cannot say relative in the last 200 years because the allowed value is 1-100.

       

      Thanks,