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.
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" )
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 |
---|---|
113 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |