Use Visual table and Data point table in Power BI Desktop

In Power BI Desktop you can drill into the details of a visualization, and see textual representations of the underlying data or the individual data records for the selected visual. These features are sometimes referred to as click-through, drill-through, or drill-through to details.

You can use Visual table to view the data in a visual as a table, or use Data point table to view a table of the data used to calculate a single data point.

Visual table and Data point table

Important

Visual table and Data point table support only the following visualization types:

  • Bar chart
  • Column chart
  • Donut chart
  • Filled map
  • Funnel
  • Map
  • Pie chart
  • Treemap

Use Visual table in Power BI Desktop

Visual table shows you the data underlying a visualization. Visual table appears in the Data/Drill tab in the Show section of the ribbon when a visual is selected.

Visual table in ribbon

You can also see the data by right-clicking on a visualization, and then selecting Show Data from the menu that appears; or by selecting More options (...) in the upper-right corner of a visualization, and then selecting Show as a table.

Show Data right-click  Show Data More Options

Note

You must be hovering over a data point in the visual for the right-click menu to be available.

When you select Visual table or Data point table, the Power BI Desktop canvas displays both the visual and the textual representation of the data. In the horizontal view, the visual is displayed on the top half of the canvas, and the data is shown on the bottom half.

horizontal view

You can toggle between the horizontal view and a vertical view by selecting the icon in the upper-right corner of the canvas.

vertical view toggle

To get back to the report, select < Back to Report in the upper-left corner of the canvas.

Back to Report

Use Data point table in Power BI Desktop

You can also focus on one data record in a visualization, and drill into the data behind it. To use Data point table, select a visualization, then select Data point table in the Data/Drill tab in the Visual Tools section of the ribbon, and then select a data point or row on the visualization.

Data point table in ribbon

Note

If the Data point table button in the ribbon is disabled and grayed-out, it means the selected visualization does not support Data point table.

You can also right-click a data element and select Data point table from the menu that appears.

Data point table by right-click

When you select Data point table for a data element, the Power BI Desktop canvas displays all the data associated with the selected element.

Screenshot of a canvas, showing all the data associated with the selected element when you select Data point table.

To get back to the report, select < Back to Report in the upper-left corner of the canvas.

Note

Data point table has the following limitations:

  • You can't change the data in the Data point table view and save it back to the report.
  • You can't use Data point table when your visual uses a calculated measure in a (multidimensional) measure group.
  • You can't use Data point table when you are connected to a live multidimensional (MD) model.

Next steps

There are all sorts of report formatting and data management features in Power BI Desktop. Check out the following resources for a few examples: