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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
EsmeeSnijders
Regular Visitor

Latsest date - Opening Power BI Service

Hello, I need some help. 

 

I have a date slicer in my report, that goes up to yesterday. By Excluding today in the filter. See below: 

EsmeeSnijders_0-1689762312514.png

 

 

I would like when I open the report in Power BI service, that it opens on yesterday as the max date of my date slicer. Not the date I left the report the last time I opened it. 

 

Can somebody help me? 

2 REPLIES 2
v-rongtiep-msft
Community Support
Community Support

Hi @EsmeeSnijders ,,

I have created a simple sample, please refer to it to see if it helps you.

Create a measure.

Measure = var _1= TODAY()-1
return
IF(MAX('Table'[Date])=_1,1,BLANK())

vrongtiepmsft_0-1689904256835.png

I have also found a similar post, pleas erefer to it to see if it helps you.

Solved: Setting default date slicer to yesterday - Microsoft Fabric Community

1. Create a slicer with your date column. 
2. At the right top of the slicer, choose Relative as slicertype. 
3. Now you will have 3 items to fill in your slicer, set them like the following: | This | - | Year |
4. Open the Format pane for your slicer and open the Date Range options. 
5. Set the toggle for Include today to off. 

 

 

How to Get Your Question Answered Quickly 

 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

 

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

Hi, 

 

Thank you so much for your reaction. 

 

Indeed this works to get the date filter to go up to yesterday. 

 

What i want, is that when I open the report in Power BI service, the report opens at the last available date in the date filter. 

For example: I leave the report unopened for a couple of days. Let's say 2023.07.21 was the last date I opened the report. Which means the datefilter was on 2023.07.20 (Yesterday). 

When I reopen the report on 2023.07.30, I want the date slicer to open on 2023.07.29, not the 2023.07.20 I left it at the last time i opened it. 

 

I hope this is a clear example. 

 

Thank you in advance. 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.