Forum Discussion
slicer with hardcoded date range
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 janu...
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?
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.