Default Date in the Slicer

[LyncoData1]

Hello,

I am using the Between format for the Date slicer. What I need is to set the end date of the date range to yesterday date, so everytime I open the dashboard ,it shows 1/1/2020 - Yesterday. I would like the slicer to always default from the first of January to yesterday. Please suggest how to achieve this. Thanks.

[v-easonf-msft]

Hi, @LyncoData1 

The selection of the default value of the slicer is not yet supported as below.

The only effect that can be achieved is what mentioned by @lkalawski  .

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

You can use relative date filter till yesterday

[lkalawski]

---

@amitchandak wrote:

You can use relative date filter till yesterday

---

amitchandak, the filter does not have the "till" option, so this solution will not pass.

[lkalawski · Accepted solution]

The best solution would be to create an additional column to check if the date is less than today. If so, show date, if not blank (). And add this new column to the slicer.

to Yesterday Date =
IF ( DATEDIFF ( 'Date'[Date], TODAY (), DAY ) >= 1, 'Date'[Date], BLANK () )

Result:

 

_______

If I helped, please accept the solution and give kudos! 😊

[Anonymous]

Hi,

Is there a way to default the from date to Yesterday?

Regards,

Raj

[tctrout]

Place a filter on that filter visual to be in the last 1 days.