For a given date: Default: the slicer should default to show the last 14 days including today.

[subhashredz]

• Default: the slicer should default to show the last 14 days including today.
• Maximum Range: the slicer should have a maximum range of 90 days
• Data should be pulled at a maximum of rolling three years prior from today

[Anonymous · Accepted solution]

Hi @subhashredz ,

Requirement 1 and 2:

You can create a measure to filter your date slicer. You can create a date table by CALENDAR() date with maximum range of 90 days.

Date = CALENDAR(TODAY()-90+1,TODAY())

Selection = 
{"Maximum Range"}

Measure:

Measure = 
VAR _DATESTART = MIN('Date'[Date])
VAR _DATEEND = MAX('Date'[Date])
RETURN
IF(ISFILTERED(Selection[Value]),1,IF(_DATESTART > TODAY()-14 && _DATEEND<=TODAY(),1,0))

Result is as below.

By Default:

Select "Maximum Range":

Requirement 3:

You can try incremental refresh in Power BI.

For reference:

Incremental refresh and real-time data for datasets

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[subhashredz]

@Anonymous 

Thanks for the reply

The Requirment is that the user can select any 90 days of max range from last 3 years.

And can we achive all the 3 requirments in only one slicer without any aditional check box selection. 

Regards,

Subhash