Forum Discussion

S_Berg's avatar
S_Berg
Frequent Visitor
3 years ago
Solved

Filter multiple date fields with 1 slicer

I have 4 visuals showing projects in different statuses. I want to show the differet project types in a specified date range by using one slicer the user can adjust. One of the problems I am having i...
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi  S_Berg ,

     

    Sorry, as far as I know, it may not be possible to use only one measure to filter 4 Visual different date fields, which will cause conflicts in the conditions, you can create 4 measures and place them in different Visual settings is=1.

    Here are the steps you can follow:

    1. Create measure.

    New Projects =
    var _mindate=MINX(ALLSELECTED('Date'),'Date'[Date])
    var _maxdate=MAXX(ALLSELECTED('Date'),'Date'[Date])
    return
    IF(
        MAX('Table'[Added])>=_mindate&&MAX('Table'[Added])<=_maxdate,1,0)
    ACTIVE =
    var _mindate=MINX(ALLSELECTED('Date'),'Date'[Date])
    var _maxdate=MAXX(ALLSELECTED('Date'),'Date'[Date])
    return
    IF(
        MAX('Table'[Status])>=_mindate&&MAX('Table'[Added])<=_maxdate&&MAX('Table'[Finished])=BLANK(),1,0)
    Pending Projects =
    var _mindate=MINX(ALLSELECTED('Date'),'Date'[Date])
    var _maxdate=MAXX(ALLSELECTED('Date'),'Date'[Date])
    return
    IF(
        MAX('Table'[Status])<_mindate|| MAX('Table'[Added])>_maxdate&&MAX('Table'[Finished])=BLANK(),1,0)
    New Projects =
    var _mindate=MINX(ALLSELECTED('Date'),'Date'[Date])
    var _maxdate=MAXX(ALLSELECTED('Date'),'Date'[Date])
    return
    IF(
        MAX('Table'[Added])>=_mindate&&MAX('Table'[Added])<=_maxdate,1,0)

    2. Place the four Measures in different Visual Filters and set is=1.

    3. Result:

     

     

    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