Need help on drill-through filter

[cuseman03]

Hi,

Stuck on some PBI stuff and hoping all you experts can help out.  Essentially, I think what I am trying to do is like a self-join in terms of business logic.  I have 2 charts.  The top one is filtered to today dateadd(day, -0).  The bottom one, when you click one one of the records from the top table, I want to drill into that record in a line graph but I want to see drill in values for past 3 days.  Problem is when you click on the parent record it drill only into today's date because that's what the parent chart is filtered on.  I have a backend sql query bringing back the last 30 days, so the raw data is there, it's being able to manipulate a drill in view to not filter on what you're clicking on to view in the parent.  

Thanks!

[Anonymous]

Hi @cuseman03,

Thanks @johnt75 for Addressing the issue.

we would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Regards,
Vinay Pabbu

[cuseman03]

I think this is correct but there's no way I can make it work because I can't create date tables like they have with detailed data.  My date tables only have one column  and it's just the date.

[johnt75]

It would work even with just the date column, its just a matter of tweaking how you build the filter on the Previous Dates table

[johnt75 · Accepted solution]

I think you can adapt the techniques described in https://www.sqlbi.com/articles/show-previous-6-months-of-data-from-single-slicer-selection/ . Use 'Date'[Date] on the table and 'Previous Date'[Date] on the chart.