Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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,
Solved! Go to Solution.
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.
Hey jdbuchanan71,
Thanks heaps - you are a genius!
I so needed this to do fiscal year to date Budget against year to date Actuals.
So I still have Date as >= 1 July
BUT now with your help, the DateOffset is set <1
Problem fixed. Thanks for posting this
If you are using Power BI Date/Calendar table then change the Date table as below.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |