In this example, the Sales team wants to drill into the details of individual products to understand the sales trend by channel.
- Open a report in Power BI Desktop and add a report page with the name Product Details.
- Drag the Product Name column from the Product dimension table to the Drillthrough filters field well.
Drillthrough Filter Field Well with Product Name Column
- 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 ...
