Question

You are building a sales report. On the summary page, a matrix shows total sales by product category. Managers want to right-click any category and jump to a dedicated page that shows detailed transactions and KPIs filtered to only that category. What should you configure on the detail page to enable this behavior?

Accepted Answer

Add the Category field to the Drill through filter well on the detail page.

Answer

Enable Sync slicers between the summary page and the detail page for the Category field.

Answer

Create a report-level filter on Category and set it to require single selection.

Answer

Add a bookmark that captures the Category slicer state and assign it to a button.