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 ...
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

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