使用 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
  • 如果视觉对象使用计算度量值,则不能使用查看记录You can't use See Records when your visual uses a calculated measure
  • 连接到实时多维 (MD) 模型时无法使用查看记录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: