cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dataman123 Member
Member

Sync Data Slicer to always shoe todays date as to date

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

Capture.JPG

4 REPLIES 4
Super User
Super User

Re: Sync Data Slicer to always shoe todays date as to date

Hello @dataman123 

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.

 

today.jpgTomorrow the row for 7/13/2019 will be marked as "Today"

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" )

 

Super User
Super User

Re: Sync Data Slicer to always shoe todays date as to date

@dataman123  You can try using relative date filtering either in slicer visual or Filters pane as shown below

 

image.pngimage.png



Did I answer your question? Mark my post as a solution !

Proud to be a Datanaut !





Super User
Super User

Re: Sync Data Slicer to always shoe todays date as to date

@dataman123 Ignore my suggestion, go with @PattemManohar reccomendation.  Putting the date on the slicer and setting it to Relative > This Day will make moving selection.

dataman123 Member
Member

Re: Sync Data Slicer to always shoe todays date as to date

@PattemManohar this will work but i want the date slice to look at all dates up to todays date. Thank you

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Users Online
Currently online: 328 members 3,589 guests
Please welcome our newest community members: