使用 Power BI Desktop 中的查看資料和查看記錄Use See Data and See Records in Power BI Desktop

Power BI Desktop 中,您可以向下鑽研任何視覺效果的詳細資料,並查看所選視覺效果資料或個別資料元素的文字表示。In Power BI Desktop you can drill into the details of any visual, and see a textual representation of the data or individual data elements for a selected visual. 這些功能有時稱為「點選」,或「鑽研」或「鑽研到詳細資料」。These features are sometimes referred to as click-through, or drill-through or drill-through to details.

您可以使用 [查看記錄] 檢視某視覺效果一個所選資料元素的基礎資料列,或使用 [查看資料] 檢視視覺效果中所用值的文字版本。You can use See Records to view the underlying rows for one selected data element from a visual, or use See Data to view a textual version of the values used in the visual. 使用 [查看資料] 和 [查看記錄] 有一些限制,會在這篇文章的結尾討論。There are some limitations to using See Data and See Records, which are discussed at the end of this article.

在 Power BI Desktop 中使用查看資料Using See Data in Power BI Desktop

[查看資料] 按鈕位於功能區 [視覺效果工具] 的 [資料/鑽研] 索引標籤。The See Data button is located in the Data / Drill tab in the Visual Tools section of the ribbon.

您也可以在視覺效果按一下滑鼠右鍵,然後從出現的功能表選取 [查看資料],來查看資料You can also See Data by right-clicking on a visual, then selecting See Data from the menu that appears.

注意

您的滑鼠必須在視覺效果的資料點暫留,才能使用滑鼠右鍵功能表。You must be hovering over a data point in the visual in order for the right-click menu to be available.

當您選取 [查看資料] 時,Power BI Desktop 著重於您選取的視覺效果和資料,並將畫布空間專用於顯示視覺效果和資料的文字表示。When you select See Data, Power BI Desktop focuses on the visual and data you selected and dedicates the canvas space to displaying the visual and the textual representation of the data. 視覺效果會顯示在畫布上的上半部,資料會顯示在下半部,如下圖所示。The visual is displayed on the top half of the canvas, and the data is shown on the bottom half, as shown in the following image. 這是「水平」檢視。This is the horizontal view.

您也可以選取右上角的圖示切換到「垂直檢視」 (或回到「水平檢視」)。You can also switch to a vertical view (or back to horizontal view), by selecting the icon in the upper right corner.

若要回到報表,請選取畫布左上角的 [< 回到報表]。To get back to the report, select < Back to Report in the upper left corner of the canvas.

在 Power BI Desktop 中使用查看記錄Using See Records in Power BI Desktop

您也可以將焦點放在視覺效果中的一個資料元素,並向下鑽研其背後的資料。You can also focus on one data element in a visual, and drill into the data behind it. 一旦選取了視覺效果,有兩種方式可使用 [查看記錄]:您可以在 [資料/鑽研] 功能區啟用 [查看記錄] 切換按鈕,然後按一下資料元素,或者您可以用滑鼠右鍵按一下資料元素,並從出現的功能表選取 [查看記錄]。Once a visual is selected there are two ways to use See Records; you can enable the See Records toggle button in the Data / Drill ribbon and then click on a data element, or you can right-click on a data element and select See Records from the menu that appears.

注意

如果選取的視覺效果不支援 [查看記錄],則功能區上的按鈕會呈現灰色。If the selected visual does not support See Records then the button on the ribbon is grayed out.

選取 [查看記錄] 之後,Power BI Desktop 會著重在該個別資料元素,並將畫布空間專用於顯示該元素的資料,如下圖所示。Once See Records is selected, Power BI Desktop focuses on that individual data element and dedicates the canvas area to displaying the data for that element, as shown in the following image.

若要回到報表,請選取畫布左上角的 [< 回到報表] 按鈕。To get back to the report, select the Back to Report button in the upper left corner of the canvas.

限制Limitations

使用 [查看資料] 或 [查看記錄] 時有幾項限制要考慮:There are a few limitations to consider when using See Data or See Records:

  • 只支援下列視覺效果類型︰Only the following visual types are supported:
    • 橫條圖Bar
    • 直條圖Column
    • 地圖Map
    • 樹狀圖Tree Map
    • 區域分布圖Filled Map
    • 圓形圖Pie
    • 環圈圖Donut
    • 漏斗圖Funnel
  • 當視覺效果使用導出量值時,則無法使用 [查看記錄](See Records)You can't use See Records when your visual uses a calculated measure
  • 連接到即時多維度模型 (MD) 時,您不能使用 [查看記錄](See Records)You can't use See Records when connected to a live multidimensional (MD) model

後續步驟Next steps

Power BI Desktop 有各種報表格式和資料管理功能。There are all sorts of report formatting and data management features in Power BI Desktop. 請查看下列資源以取得一些範例︰Check out the following resources for a few examples: