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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
Super User
Super User

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.