Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Keep drill through filter values between pages

Hi,

 

I have an Overview page with a few line/bar charts, each one being split by site (A, B, C) - I have Site on top of Date in the X-axis section. For each chart there is a separate table used as a data source, no relationship between them. For each chart I created a page with more details (Details1, Details2) configured as Drillthrough with Keep all filters = Off and Drill through from = Site.

 

This works, I click on a value in the Overview page and the corresponding page filtered by Site shows up (depending where the value was). But the site filter is automatically added to "Filters on this page" section. I need it to be on "Filters for all pages" (except Overview).

In other words, what I need is to be able to switch bewtween the details pages directly (without going via the Overview page) and have the Site filter retain its value. So if I click on a value in Site A on the Overview page and select drillthrough I get to Details1 filtered by Site= A. But when I click on another page (Details2) the Site filter doesn't stick to Site= A, but is set to whatever value it had before (All or another site).

 

Is there a way to acomplish this?

  • One drillthrough can only be setup to navigate to one page. Could you use Site as a slicer and sync slicers across your different pages? Would that meet the need?

2 Replies