Select Slicer default yesterday with all dates showing

[MustafaP]

Hi Everyone,

I need support for my report, it has data from 2023 till 2025.

I have a date filter and i want to select automaticly yesterday in first openning but with all dates, user can change if they want.

for today selected 26.08, but tomorrow when you open this report, i would like to selection default will be 27.08, and goes on.

How i can do it?

Thank you

[shafiz_p]

Hi @MustafaP  Create a custom column in power query to identify yesterday and sorting. See the image below for custom date column.

Sort in descending order.

Change type to text.

Now create a slice with the custom column and sort descending.

Set slicer setting to only single select. See image below:

Now yesterday will always be selected and change automatically each day at the top when you refresh. Alongside, you can filter other day too.

Hope this helps!!
If this solved your problem, please accept it as a solution!!

[MustafaP]

almost done but sorting not worked.

[shafiz_p · Accepted solution]

I have check today and refreshed , It is still working for me. 

Let's do it in other way. 

Open power query: Before creating any steps, first sort the date column in ascending order. See image below:

Create an index column starting from 1.

Now do the steps to create only custom column to identify yesterday.

Again create a condition custom column to sort the custom date column.

Now remove the index column and change type of custom column to text and SortIndex column to whole number.

Sort the sortindex column in ascending order, and close and load.

Go to the table view and sort the custom column by SortIndex column.

Hope this will work!!
If this solved your problem, please accept it as a solution!!

Best Regards,
Shahariar Hafiz

[MustafaP]

thank you so much...

[dharmendars007]

Hello @MustafaP , 

You can create Conditional Column like the below and add it as filter in the filter section to restrict dates till yesterday..

If you find this helpful , please mark it as solution and Your Kudos are much appreciated!

Thank You

Dharmendar S

LinkedIN 

[MustafaP]

But i want to report came with yesterday selected.

[dharmendars007]

Hello @MustafaP , 

You can try with the below Calculated column, this is dynamic and use this as Filter.

Condition = IF(TODAY()-1=Dates[Dates], "True", "False")

If you find this helpful , please mark it as solution and Your Kudos are much appreciated!

Thank You

Dharmendar S

LinkedIN