selected Data range slicer shouldbe max date -1

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.