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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
ThomasCh
Frequent Visitor

Date slicer automatically up until yesterday on opening report

Hello,

I have a problem with the date slicer in Power BI. I want the date slicers max date to be on yesterday's date upon opening. I have achieved this in one report prior, but I cannot replicate this. 

 

I have a calculated column on the date table in the dataset named "Date Intervals". This contains attributes like "Dates up to Yesterday", "Future Dates", "Today", and "Yesterday". 

ThomasCh_0-1688132987944.png

 

When selecting "Dates Up To Yesterday" and "Yesterday" as a filter in a report, the max date I can choose is yesterdays date. However, if I open the report in the service the day after that, the max date on the slicer is still on the date I published the report. I have tried to turn off "Persistent filters" in the report file, I have tried to connect the report to another dataset, and I have even tried to copy the report file where this works, and add the visualisations I need. Still, it doesn't work! 

Underneath is a screenshot of the report where this works. Today is the 30th of June, and when opened, it shows 29th of June, as expected.

ThomasCh_1-1688133357104.png

 

What should I do to make this work on my other report? 

0 REPLIES 0

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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