Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Looking to see if there is a way to set a date slicer to always look up to todays date as a default. Rather than this needing to be moved each day
@Anonymous You can try using relative date filtering either in slicer visual or Filters pane as shown below
Proud to be a PBI Community Champion
@PattemManohar this will work but i want the date slice to look at all dates up to todays date. Thank you
@Anonymous Ignore my suggestion, go with @PattemManohar reccomendation. Putting the date on the slicer and setting it to Relative > This Day will make moving selection.
Hello @Anonymous
If you add a column to your date table using this code.
Date (today) = IF ( Dates[Date] = TODAY(), "Today", FORMAT ( Dates[Date], "m/d/yyyy" ) )
Then you can put the [Date (today)] field in your slicer and pick "Today". Whenever the model refreshes (I assume that is daily) this column will get calculated and the row that is marked as "Today" will shift. Since your slicer is set to pick the row that is marked as "Today" your selection moves with it.
If you con't care about seeing the other dates and only care about "Today" moving you can change the code to this.
Date (today) = IF ( Dates[Date] = TODAY(), "Today" )