Double Drilldown Possible?

[jl20]

Hello,

I am wondering if it is possible to drill down to an intermediate page and then to the row level detail in a table? For example:

Tab 1 - Summary, lists sales for each of the last six trailing weeks on bar chart. I want to right click on a week and drilldown to a second report page [Tab 2 in this example] that has two charts: i) Sales by location; and ii) Sales by product type. I've successfully been able to achieve this.

Tab 2 [Drillthrough] - Subset of Tab 1, whereby the data is filtered to show only one of the six trailing weeks on two bar charts. I then want to be able to right click on one of the bars (for example, "New York" on the sales by location bar chart and drill to the transaction detail, filtered to show: Week = 1; Location = New York. However, when I tried to accomplish this, only New York is passed through to Tab 3 [detail], and it shows data for all weeks.

Is it possible to pass through filters, effectively drilling down on an already drilled down page?

Thanks in advance!

[v-yuezhe-msft · Accepted solution]

@jl20，

In your scenario, you would need to drag week field to Legend of the Sales by location bar chart and drag the week field to the Drillthrough filters of Tab3, this way, you can drill through from Tab2 to Tab3 with Week = 1 and Location = New York filters.

Regards,
Lydia

[jl20]

That worked - thanks! The thing I was missing was putting multiple fields in the drillthrough filter.