Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
LyncoData1
Helper I
Helper I

Default Date in the Slicer

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.

 

Date Key.PNG

1 ACCEPTED SOLUTION
lkalawski
Memorable Member
Memorable Member

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:

Ex1.png 

_______

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

View solution in original post

6 REPLIES 6
v-easonf-msft
Community Support
Community Support

Hi, @LyncoData1 

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

47.png


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

45.png

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
Super User
Super User

You can use relative date filter till yesterday


@amitchandak wrote:

You can use relative date filter till yesterday


lkalawski
Memorable Member
Memorable Member

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:

Ex1.png 

_______

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

Anonymous
Not applicable

Hi,

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

Regards,

Raj

tctrout
Resolver III
Resolver III

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors