Forum Discussion
filter date slicer before today
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.
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?
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,
Do you have a date table you are using?
Yes, the slicer use Date table can be up to year 2154
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.