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 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
2 Replies
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.
