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

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

 

thanks

 

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

3 Replies

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

  • v-kkf-msft's avatar
    v-kkf-msft
    Community Support
    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