The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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".
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.
What should I do to make this work on my other report?