Question

You build a sales report with a summary matrix showing revenue by product category. Executives want to click any category and land on a dedicated page that shows detailed transactions filtered to only that category, while keeping the ability to return to the summary. You have already created a detail page with the transaction table. What is the minimum configuration required so that right-clicking a category navigates to the filtered detail page?

Accepted Answer

Add the ProductCategory field to the 'Drill through' well on the detail page, which auto-generates a back button and passes the selected category as a filter.

Answer

Create a bookmark for each category on the detail page and attach them to buttons on the summary matrix.

Answer

Enable a page-level filter on the detail page set to a single category and duplicate the page for every category.

Answer

Add ProductCategory to a sync slicer on both pages and set the interaction to cross-filter.