在 Power BI Desktop 中使用鑽研Use drillthrough in Power BI Desktop

使用 Power BI Desktop 中的鑽研,您可以在報表中建立頁面,著重於特定的實體 - 例如供應商、客戶或製造商。With drillthrough in Power BI Desktop, you can create a page in your report that focuses on a specific entity - such as a supplier, or customer, or manufacturer. 使用該焦點報表頁面,使用者可以滑鼠右鍵按一下其他報表頁面中的資料點,然後鑽研至著重頁面,取得經過篩選為該內容的詳細資料。With that focused report page, users can right-click on a data point in other report pages, and drillthrough to the focused page to get details that are filtered to that context.

使用鑽研Using drillthrough

若要使用鑽研,請建立報表頁面,其中包含您想要查看您將為其提供鑽研之實體類型的視覺效果。To use drillthrough, create a report page that has visuals you'd like to see about the type of entity for which you'll provide drillthrough. 例如,如果您想要為製造商提供鑽研,您可能會建立鑽研頁面,並使用顯示總銷售額、總出貨單位數、依類別分類的銷售額、依區域分類的銷售額等等的視覺效果。For example, if you're interested in providing drillthrough for manufacturers, you might create a drillthrough page with visuals that show total sales, total units shipped, sales by category, sales by region, and so on. 這樣一來,當您鑽研至該頁面時,視覺效果將專屬於您按一下並選取鑽研的製造商。That way, when you drillthrough to that page, the visuals will be specific to the manufacturer you clicked on and selected to drillthrough about.

然後在該鑽研頁面上,[視覺效果] 窗格的 [欄位] 區段中,拖曳您想要鑽研的欄位至 [鑽研篩選]。Then on that drillthrough page, in the Fields section of Visualizations pane, drag the field you want to drillthrough about into the Drillthrough filters well.

當您將欄位新增至 [鑽研篩選] 時,Power BI Desktop 會自動建立「返回」按鈕視覺效果。When you add a field to the Drillthrough filters well, Power BI Desktop automatically creates a back button visual. 該視覺效果會變成已發行報表中的按鈕,且讓正在 Power BI 服務中使用報表的使用者輕鬆地回到來源報表頁面 (他們在其中選取鑽研的頁面)。That visual becomes a button in published reports, and lets users who are consuming your report in the Power BI service easily get back to the report page from which they came (the page from which they selected to drillthrough).

因為「返回」按鈕是個影像,您可以使用任何想要的影像來取代視覺效果的影像,它將仍會正常運作為按鈕,讓報表使用者能回到其原始頁面。Since the back button is an image, you can replace the image of that visual with any image you want, and it will still operate properly as the button to get report consumers back to their original page. 若要使用自己的影像作為返回按鈕,只要在鑽研頁面上放一個影像視覺效果,然後選取視覺效果,並開啟「返回按鈕」滑桿。To use your own image for a back button just place an image visual on the drillthrough page, then select the visual, and put the Back button slider to on. 如此可讓您的影像運作為「返回」按鈕。That makes your image function as a back button.

鑽研頁面完成之後,當使用者以滑鼠右鍵按一下您的報表中的資料點,而它使用您放入鑽研頁面上之 [鑽研篩選] 的欄位時,隨即出現操作功能表,讓使用者鑽研至該頁面。When your drillthrough page is complete, when users right-click on a data point in your report that uses the field you put into the Drillthrough filters well on your drillthrough page, a context menu appears, letting the users drillthrough to that page.

當他們選擇鑽研時,頁面會篩選為顯示他們以滑鼠右鍵按一下之資料點的相關資訊。When they choose to drillthrough, the page is filtered to show information about the data point from which they right-clicked. 比方說,如果他們以滑鼠右鍵按一下與 Contoso (製造商) 有關的資料點,然後選取要鑽研,則他們到達的鑽研頁面會篩選為 Contoso。For example, if they right-clicked on a data point about Contoso (a manufacturer), and selected to drillthough, the drillthrough page they were taken to would be filtered to Contoso.

注意

只有鑽研篩選中的欄位會傳遞至鑽研報表分頁。Only the field that is in the Drillthrough filters well gets passed through to the drillthrough report page. 不會傳遞其他任何內容資訊。No other contextual information is passed.

以上就是在報表中使用鑽研的相關資訊。And that's all there is to using drillthrough in your reports. 這是取得您為鑽研篩選選取的實體資訊之展開檢視的好方法。It's a great way to get an expanded view on the entity information you select for your drillthrough filter.