Events
Power BI DataViz World Championships
Feb 14, 4 PM - Mar 31, 4 PM
With 4 chances to enter, you could win a conference package and make it to the LIVE Grand Finale in Las Vegas
Learn moreThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
APPLIES TO:
Power BI service for business users
Power BI service for designers & developers
Power BI Desktop
Requires Pro or Premium license
A Power BI visual is constructed using data from underlying semantic models. If you're interested in seeing behind the scenes, Power BI shows you the data that's being used to create a visual. The ability to do this is available in Power BI Desktop and in the Power BI service and is available for almost all visual types.
You can also export the data to Excel for visuals in a report and visuals on a dashboard.
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.
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, 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.
Note
If the Data point table button in the ribbon is disabled and grayed-out, it means the selected visual does not support Data point table.
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.
Show data point as a table (Power BI service) and Data point table (Power BI Desktop) views
Show as a table (Power BI service) and Visual table (Power BI Desktop) views
There are all sorts of report formatting and data management features in Power BI. Check out the following resources for a few examples:
Events
Power BI DataViz World Championships
Feb 14, 4 PM - Mar 31, 4 PM
With 4 chances to enter, you could win a conference package and make it to the LIVE Grand Finale in Las Vegas
Learn moreTraining
Module
Design interactive data experiences with Power BI Desktop - Training
Power BI enables report authors to produce interactive reports using visuals, slicers, bookmarks, and more.
Certification
Microsoft Certified: Power BI Data Analyst Associate - Certifications
Demonstrate methods and best practices that align with business and technical requirements for modeling, visualizing, and analyzing data with Microsoft Power BI.