Month Between Slicer

[zausten]

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 minus x no of months.  

Timeline slicer on app store is along right lines but is massive and takes up to much space.

thanks

[v-kkf-msft · Accepted solution]

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

[zausten]

thanks @v-kkf-msft works as requested

[lbendlin]

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