Powerbivisual

[Millar]

Need to create a date filter by using slicer which contain start date and end date
when ever report gets loaded its should show default values form
start date should be :01-Feb-2023
end date should be: Today's day ( dynamically)

also when ever user want to change the same start data and end date those option also need to enable in slicer.

[Anonymous · Accepted solution]

Hi  @Millar ,

I created some data:

Here are the steps you can follow：

1. Create calculated table.

Table 2 =
DISTINCT('Table'[Date])

2. Create measure.

Flag =
var _mindate=
MINX(ALLSELECTED('Table 2'),'Table 2'[Date])
var _maxdate=
MAXX(ALLSELECTED('Table 2'),'Table 2'[Date])
return
IF(
    ISFILTERED('Table 2'[Date])=FALSE()&&MAX('Table'[Date]) >=DATE(2023,2,1)&&MAX('Table'[Date])<=TODAY(),1,
    IF(
    ISFILTERED('Table 2'[Date])=TRUE()&&MAX('Table'[Date]) >=_mindate&&MAX('Table'[Date])<=_maxdate,1,0))

3. Place [Flag]in Filters, set is=1, apply filter.

4. Result:

Slicer has no selected value

Slicer selected value

Best Regards,

Liu Yang

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

[Millar]

New column created under table level

Period = if('DMADP OPEM_ADP_DATE_D'[Date]>EOMONTH(TODAY(),-12)&&'DMADP OPEM_ADP_DATE_D'[Date]<=TODAY(),1,0)

And placed under page filter level set values as 1