Power Pivot reporting properties: Adding descriptions to Power View tables, columns, and fields

Note: This article has done its job, and will be retiring soon. To prevent "Page not found" woes, we're removing links we know about. If you've created links to this page, please remove them, and together we'll keep the web connected.

In Power Pivot you can add descriptions for the tables, fields, and columns in Power View. When working in Power View, these descriptions will appear when you hover on the table, field, or column. By adding descriptions for tables, fields, and measures, you’ll make it easier for coworkers to create reports and also easier for others to understand and use your shared reports.

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.
  1. Open Power Pivot > Manage.

  2. Select the Data View: Home > View > Data View

  3. To add a description to a:

    • Column: select the column, right-click, and select Description.

      Add Description to a column

    • Table: right-click the table tab and select Description.

      Add descriptions to a table

    • Field: right-click the calculated field (or measure) and select Description.

      Add description to a field or measure

  4. Back in Power View, hover over the table, field, or column to display the description.

    Column Description Hover

Note: When you add descriptions in Power Pivot, you are making changes to the underlying data model. So when you return to Power View, you’ll be prompted to refresh the data in your workbook.

Top of Page

See Also

Power View and Power Pivot videos

Power View: Explore, visualize, and present your data

Tutorial: PivotTable data analysis using a Data Model in Excel

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.