咨询：Pentaho报表迁移至Power BI后能否实现单元格点击钻取

Hey there! Great question—yes, Power BI absolutely supports cell-level drill-through functionality that matches what you're used to in Pentaho. Let me break down how to set this up and use it:

1. First: Get your data model ready #

Just like in Pentaho, drill-through relies on having a properly structured data model with hierarchical relationships (think: Year → Quarter → Month for dates, or Category → Subcategory → Product for inventory). Make sure your tables are linked correctly in the Power BI Data view so the tool knows how to traverse levels.

2. Basic cell-click drill-through for hierarchies #

Once your model is set, using drill-through on a table is intuitive:

• Right-click method: Right-click any cell in your table, hover over Drillthrough in the menu, then select Drill down to jump to the next level of detail. To go back up, right-click again and choose Drill up.
• One-click mode: Click the small drill icon in the top-right corner of your table visualization to enable drill mode. Now you can just left-click any cell to instantly drill down to the next level—this is the closest to the Pentaho click-to-drill experience you're familiar with.

3. Custom drill-through to a dedicated detail page #

If you want to click a cell and jump to a custom detail report page (instead of just drilling through hierarchy levels), here's how to set that up:

1. Create a new page in your report that will act as your detail view (add visuals like detailed charts, tables, or metrics specific to the data you want to show).
2. Go to the Page information panel (right side of the screen, under the View tab), check the box for Drillthrough target, and select the fields you want to pass to this page (e.g., Order ID, Customer ID).
3. Back on your main table page, right-click a cell from the field you set as the drill-through trigger, hover over Drillthrough, and select the name of your detail page. Now clicking that cell will jump straight to the custom detail view with filtered data.
4. For even more control, you can add a custom action to the table: Go to the Format tab for the table, expand Actions, add a Drillthrough action, specify your target page and trigger field—this makes the drill-through automatic when anyone clicks the cell.

4. Quick tips to avoid hiccups #

• Double-check your data model relationships if drill-through isn't working—broken links will prevent Power BI from pulling the right detail data.
• If you're publishing to the Power BI Service, make sure all users have access to the drill-through target page, otherwise they won't be able to use the feature.

内容的提问来源于stack exchange，提问作者t0rres