slicer with hardcoded date range

[jan_V2]

i have a table as data, and i want a window where if you tick a box, or using a drop down you can select a specific range using a name.

for example if you select range 1 you see all data from 5 january 2020 trough 10 january 2020.

i've tried a lot of things already, by it never seems to work properly.

for example, if i try to use groups, it looks like this

[FreemanZ]

hi @jan_V2 

supposing you have a table with two columns only, range and date. A range covers multiple dates.

If you feed the range column to a slicer and date column to a table visual. Then when you select a range on the slicer, the table visual shall present you the corresponding list of dates. Or?

[jan_V2]

i have found a way to create ranges using dax:

Column = SWITCH( TRUE(),

    [datetime]<= DATE(2021, 1, 10)  ,"group", "rest"

)

but the problem is is that my ranges are overlapping.