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

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

  • zausten's avatar
    zausten
    Helper I
    4 years ago

    thanks v-kkf-msft works as requested