Forum Discussion
Need to find date range using timeline slicer filter
Dear Kris,
I mapped as you said and that infact is a useful solution. I can get correct start date and end date from timeslicer if I use Hierarchy (custom visual). However, if I use Timeline Slicer (again a custom visual), I am getting static dates for Start Date and End Date. So there is a last piece of bug in the viz. My code is as follows:
newStartDate = CALCULATE ( MIN ( myNewTable[newDateColumn].[Date] ), ALLSELECTED ( myNewTable[newDateColumn].[Date] ) )
newEndDate = CALCULATE ( MAX ( myNewTable[newDateColumn].[Date] ), ALLSELECTED ( myNewTable[newDateColumn].[Date] ) )
Here is a snap shot of both the scenarios:
Case 1, the Start Date and End Date should've been 02-01-2016 and 06-01-2016, but it shows 01-01-2016 and 31-12-2017 instead.
Case 2, things are intact.
The problem is that I need to use the Timeline Slicer for my viz. Am confused why it works on one viz and not on another..!!
Timeline Slicer
Hierarchy Slicer
Very strange. I'm not sure but maybe if you remove the ALLSELECTED filter from your calculations..? Custom visuals can't always be trusted.
Kristoffer