Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Filter start/end dates with a single slicer

I want to be able to let the user set a starting date and an ending date which will filter the whole dataset for projects started on or after the first date and ended on or before the second one.

 

Best I can do so far is two slicers (in 'after' and 'before' mode) but it's kinda confusing for the user. 

 

And if I want to reduce the control size to hide the useless part it shows the funnel thingy :  (what's with that anyway??!?)

 

 

How would you approach that?

Need Help

2 Replies

  • v-piga-msft's avatar
    v-piga-msft
    Icon for Resident Rockstar rankResident Rockstar
    7 years ago

    Hi Anonymous ,

     

    Why don't you try between date slicer for your scenario?

     

    By my tests, it should have the same result.

     

     

    Best  Regards,

    Cherry

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Thing is I have TWO measures to filter : the starting date and the ending date.

       

      For that filtering to work properly it needs FOUR inputs : lower and higher bounds for starting date and lower and upper bounds for ending date.

       

      What I'm looking for is a way to 'force' the higher bound of the starting date to be implicitely set as well as the lower bound of the ending date.