Forum Discussion
Custom Date Range Slicer
You can do this in two steps. First, the slicer can be used from the "Slicer" visualization where you can filter dates according to specific or relative dates. Regarding the count, please create a measure that does exactly that. Probably something like this: Measure = count('table'[variable]).
Then you just need to make sure that this measure is being filtered by the "Slicer". To do that you have to click the slicer, go to "Format" and then "Edit Interactions".
Anything else, feel free to ask.
I suppose my biggest issue is with the way that the slicer works as a slide bar instead of selection of paths by date range. Yes, currently you are correct in that I can filter dates according to specific or relative dates, but I cannot choose a range from a list that will update the begining and end dates of the slicer.
I am also required to have two seperate slicers for this method of approach, one for the creation date and a different one for the closed date of each work item since the iteration path date ranges arent linked to the creation/closed dates in any capacity.
Ideally, I would have one slicer that allows me to select the Iteration Path, and will return the corresponding closed work items and opened work items during the date range. Thanks for the help and any further suggestions would be appreciated!