Question

A report has three pages: Overview, Regional Detail, and Product Detail. Each page contains a Region slicer. Business users complain that when they select a region on the Overview page, they must reselect it after navigating to Regional Detail, but they want the Product Detail page to keep its own independent Region selection. What is the most efficient way to meet this requirement?

Accepted Answer

Enable the Sync slicers pane and, in the sync grid, check the sync boxes for the Region slicer only on the Overview and Regional Detail pages, leaving Product Detail unchecked.

Answer

Add a drillthrough filter on Region so that navigating between pages carries the selection automatically.

Answer

Set the Region slicer interaction to 'Filter' on all three pages using the Edit interactions option.

Answer

Create a bookmark for each region and add navigation buttons so users apply the same region across all pages.