Multi-column drillthrough

In many scenarios, a more specific filter context is needed for drillthrough report pages to resolve analyses. For example, the user may be interested in one specific year for a given Product Subcategory. To support these needs, multiple columns can be added as drillthrough page filters. When one or both columns are exposed in a report visual on a separate page, the drillthrough right-click option can be used to apply multiple filter selections to the drillthrough page.

In the following stacked column chart of Internet Sales by year and Product Subcategory, right-clicking on the Road Bikes column for 2015 ($4.2M) exposes the Drillthrough option to the Subcategory-Year Details drillthrough report page:

Drillthrough ...

Get Mastering Microsoft Power BI now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.