Forum Discussion
Passing Date Filter
Yes, 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
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.
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.
Sorry, that's my garbage reading skills coming into play.
I think what you need to do is write a DAX formula that will calculate the SUM of MRC, while taking into consideration the filtered date context that has been passed along.
Maybe something like this?
__MRC Total = CALCULATE(SUM(Orders[MRC]),
DATESBETWEEN('Events Slicer'[DateValue],FIRSTDATE('Events Slicer'[DateValue]),NOW()))