Show the data used to create a Power BI visual

Use Visual table to display the data underlying a visual. Visual table is available from the Data/Drill tab in the ribbon when a visual is selected.

You can also see the data by using one of these options:

• Right-click on a visual, and then select Show as a table from the menu that appears.

• Select More options (...) in the upper-right corner of a visual, and then select Show as a table.

    

When you select Visual table or Data point table, Power BI 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.

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

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

You can also focus on one data record in a visual, and drill into the data behind it. To use Data point table, select a visual to make it active. Select Data point table in the Data/Drill tab of the ribbon, and then select a data point or row on the visual.

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

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

In the Power BI service, report visuals are created from the data in the underlying semantic model. Show as a table displays the data underlying a visual. Show data point as a table displays the underlying data used to calculate a single data point.

When you select Show as a table or Show data point as a table, Power BI displays both the visual and the textual representation of the data.

1. In the Power BI service, open a report and select a visual.

2. To show the data underlying the visual, select More options (...) and choose Show as a table.

   

3. By default, the data appears below the visual.

   

4. To change the orientation, select the vertical layout icon from the upper-right corner of the canvas.

   

5. To export the data to a .csv file, select the ellipses and choose Export data.

   

For more information about exporting the data to Excel, see Export data from Power BI visualizations.

To return to the report, select Back to report from the upper left corner.

You can also focus on one data record in a visual, and drill into the underlying data. Right-click a data element and select Show data point as a table from the menu that appears.

When you select Show data point as a table for a data element, the Power BI service opens a separate screen and displays all the data associated with the selected element.

To return to the report, select Back to report from the upper left corner.