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


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.