selected Data range slicer shouldbe max date -1

[Shanvitha_V]

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

[jaweher899]

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.