Set date filter to always show a certain day

[Anonymous]

Hi all,

Is there a way to have my "date selector" slicer always set to a relative date when someone opens the page? I need the option to select a week of individual dates as you can see below so a standar relative date won't do the job, but I'd love an auto that defaulted to the day before the current date if possible (as we do daily updates).

Kind regards,

Jordan 

[amitchandak · Accepted solution]

@Anonymous , You have to create a column like this and use

Date Type = SWITCH(TRUE(),'Date'[Date]=TODAY(),"Today"
,'Date'[Date]=TODAY()-1,"Yesterday"
,'Date'[Date]&"")

sort this on date

[Anonymous]

This worked @amitchandak , thank you!

[FarhanAhmed]

You can create "Current Week" "Current Month" "Current Day" Flags in your Date Dimension that will update on every refresh and use them in slicer instead of Actual Dates.

Data should be like 

Week1

Week2

Current Week

Week4

.

.

.

Week14

.

.

Week52

That will be updated on Next Week and data will be like 

Week1

Week2

Week3

Current Week

.

.

.

Week52

A similar thing can be done with Day, Year, Month Quarter etc.

I hope this can help you.