Forum Discussion
Advocate IIIPassing Date Filter
Microsoft EmployeeHi Caitlin_Knox,
I'm wondering if anyone has an idea of how to pass through a date filter.
Have you tried also adding the corresponding Date column to Drillthrough filters on the Drillthrough page?
Based on my understanding, if the Date column is added to Drillthrough filters, the filtered date value should be passed to the Drillthrough page. :smileyhappy:
Regards
Caitlin_KnoxYes, I did add the corresponding event date there thinking it would do as you say. However, it looks like its filtering on the Company- not necessarily the date.
I created a Sample File (HERE) with all my data points populated with sample data. These are how I have my relationships set up and also the calculated columns I've added. If someone could take a look and maybe point out if I'm missing a step and this is why its not working, I'd really appreciate it. What I'm really expecting to happen is that when an events is selected on page 1 and drill through selected, I want it to show all Orders/Quotes AFTER that date. like I said, its supposed to be an ROI type report. I feel like I'm close, but missing a step or two
SjohnsonAdvocate II
Hi, I think i found your issue.
If you go into your drillthrough page, remove the preset filters you have in the "Drilltrhough" filter value. From there, the appropriate dates should be selected and passed through.
If you have preset drillthrough page filters you'll find it starts to conflict (I think).
**Edit**
I've had some issued with this workflow in one of my own dashboards as well (ie. dates not passing properly when context is set by a date slicer). My best solution so far is to use a custom column that creates a String-formatted "Date Filter" column (you can do this by concatenating some of the string-fields from a date-dimension table). I then make sure to use the string-formatted date period in the x-axis, and use the string-formatted date as the "drillthrough filter" item in the drillthrough page.- Caitlin_Knox
I don't have preset filters. The filters are populated when the drill through is initiated from Page 1. But the next step would making it all the dates 'after' the related date of the event.