Forum Discussion

NMERCIER's avatar
NMERCIER
Regular Visitor
4 years ago
Solved

How to create a FROM TO slicer

Hello everyone, I would like to create two slicer from to as in my screen below. I currently have a date column that works with the segment slicer between but I need to use it in FROM TO what should I do. do you have a lead. Thanks for your help.
Nico

 

Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    NMERCIER , When you use date, You can change slicer to Range slicer and use that as range

     

    you can get two date likes

    //only needed if table is not joined, else it will filter range of joined table

    measure=

    var _max = maxx(allselected(Date), Date[Year])

    var _min = minx(allselected(Date), Date[Year])

    return

    calculate( sum(Table[Value]), filter('Date', 'Date'[Date] >=_min && 'Date'[Date] <=_max))

     


    return

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    NMERCIER , When you use date, You can change slicer to Range slicer and use that as range

     

    you can get two date likes

    //only needed if table is not joined, else it will filter range of joined table

    measure=

    var _max = maxx(allselected(Date), Date[Year])

    var _min = minx(allselected(Date), Date[Year])

    return

    calculate( sum(Table[Value]), filter('Date', 'Date'[Date] >=_min && 'Date'[Date] <=_max))

     


    return