Filters between dates

[Hllt369]

Hi! 

 I want to know how create this in dropdown

Example






I know we can use the slicer and the between option but i want to use 2 different filters


I have one date table if a choose one of the dates the other options disappear


I want to use this 2 slicers as a filters. Thanks for the help!

[amitchandak · Accepted solution]

@Hllt369 , You need to use two table for that both are independent

In second slicer you will use filter using this measure - not is blank

countrows(Date2, Date2[Date] > maxx(allselected('Date1'), 'Date1'[Date] ) )

this will restrict 2nd slicer

Now using these two

example measure from a table

Date Range Using 2 slicer =
var _max = minx(allselected(Date1), Date1[Date])
var _min = maxx(allselected(Date2), Date2[Date])
return
calculate(countrows(Table), Filter(Table,(Table[Date] <=_max && Table[Date]) >=_min) )

refer if needed

How to use two Date/Period slicers :https://www.youtube.com/watch?v=WSeZr_-MiTg