Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Filter Pane Multi select

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!  🙂

 

 
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    6 years ago

    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.


3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    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's avatar
      Anonymous
      Not applicable
      6 years ago

      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's avatar
        v-easonf-msft
        Community Support
        6 years ago

        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.