Drillthrough Report Pages

In this example, the Sales team wants to drill into the details of individual products to understand the sales trend by channel.

  1. Open a report in Power BI Desktop and add a report page with the name Product Details.
  2. Drag the Product Name column from the Product dimension table to the Drillthrough filters field well.
Drillthrough Filter Field Well with Product Name Column
  1. Select an item from the list of values of the Drillthrough column such as Mountain-200 Silver, 42 in this example.
    • Choose an item that has transaction or fact table data associated with it and which you consider a representative sample of the ...

Get Microsoft Power BI Cookbook now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.