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

Don'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.

Reply
Shanvitha_V
Frequent Visitor

selected Data range slicer shouldbe max date -1

HI Export,
I have Date range filter based my selection my visual data should be take select date range MAX date-1

Example: I have selected date range 01-jan-2023 to 20-Jan-2023
They my visual datashould be display 01-Jan-2023 to 19-Jan-2023
 I am always change date range but should be MAX date shoukd less 1

 

Thanks

Shanvitha

1 REPLY 1
jaweher899
Impactful Individual
Impactful Individual

This can be achieved by creating a calculated column that returns the date one day before the current date, and using this calculated column as the maximum date in the data range slicer.

Here's how:

  1. Create a calculated column: In the Fields Pane, click on the drop-down menu, select "New Column," and enter the following DAX formula:

=TODAY()-1

In this formula, the TODAY function returns the current date, and subtracting 1 returns the date one day before the current date.

  1. Use the calculated column in the data range slicer: In the Fields Pane, select the date column, and add a data range slicer to the report canvas. In the data range slicer, select the calculated column created in step 1 as the maximum date.

This approach sets the maximum date in the data range slicer to be one day before the current date, ensuring that the report only shows data for dates up to yesterday.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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