Filter Pane Multi select

[Anonymous]

Hi!

I've got a Month Name/Day field which I've added to the filter pane.  I'd like users to be able to pick, say, all dates from June 1 through Aug 15 without having to click each date individually. Is this possible?  I've tried ctrl+click, alt+click, shift+click etc but can't seem to figure it out.  

Some of you might be tempted to suggest creating a slicer, but that's not possible due to a client request.  At the moment, I am only exploring filter pane based solutions.  Thank you!  🙂

[amitchandak]

@Anonymous , I tried on date, month-year and city slicer on page level filter option. Every time I am able to select more than one value with ctrl

[Anonymous]

Hi!  

Perhaps I was unclear.  Similar to your experience, I can select multiple values, but is there a way to select a range of values without having to select each item individually?  Thank you!

[v-easonf-msft · Accepted solution]

Hi , @Anonymous 

Make sure there is a date field and drag it into the visual filter pane

Then you can use "advanced filtering" to filter the data you want.

You also can take a try to create a measure "visual  filter control" and apply it to filter pane.

visual filter control = 
VAR a =
    DATE ( 2020, 06, 1 )
VAR b =
    DATE ( 2020, 08, 15 )
VAR c =
    SELECTEDVALUE ( 'Table'[Date] )
RETURN
    IF ( c >= a && c <= b, 1, 0 )

By modifying the a and b variables in measure, you can filter the desired data.

Pbix attached

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.