Forum Discussion

zausten's avatar
zausten
Helper I
4 years ago
Solved

Month Between Slicer

Hi   Does anyone know if its possible to create a Months Between Slicer.  e.g Jan-2022 to Feb-2022 .  The relative date option is not good enough as you cannot select different months, just current...
Tips and Tricks
  • v-kkf-msft's avatar
    v-kkf-msft
    4 years ago

    Hi zausten ,

     

    If there is only one date table, then I think you have to use the multi-select feature of the slicer.

     


    If you are willing to try two separate date tables, then you need to use the measure to filter the data.

     

    Measure = 
COUNTROWS (
    FILTER (
        'Table',
        'Table'[Date] >= MIN ( Dates[Date] )
            && 'Table'[Date] <= MAX ( 'Dates 2'[Date] )
    )
)

     

    Best Regards,
    Winniz

lbendlin's avatar
lbendlin
Super User
4 years ago

You can use two disconnected tables to feed individual slicers, and then use a measure as a page filter to enact the month range.