Forum Discussion

Millar's avatar
Millar
Frequent Visitor
2 years ago
Solved

Powerbivisual

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.

Tips and Tricks
  • Anonymous's avatar
    Anonymous
    2 years ago

    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

     

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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's avatar
      Millar
      Frequent Visitor
      2 years ago

      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