Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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.
Solved! Go to Solution.
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:
_______
If I helped, please accept the solution and give kudos! 😊
Hi, @LyncoData1
The selection of the default value of the slicer is not yet supported as below.
The only effect that can be achieved is what mentioned by @lkalawski .
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 wrote:You can use relative date filter till yesterday
amitchandak, the filter does not have the "till" option, so this solution will not pass.
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:
_______
If I helped, please accept the solution and give kudos! 😊
Hi,
Is there a way to default the from date to Yesterday?
Regards,
Raj
Place a filter on that filter visual to be in the last 1 days.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
145 | |
79 | |
63 | |
52 | |
47 |
User | Count |
---|---|
217 | |
89 | |
76 | |
67 | |
60 |