PowerPivot – Working with Column Properties in PowerPivot for Excel 2010
In the previous post, we saw how to combine data from multiple relational sources into a single table in PowerPivot. In this post, let us see some of the common properties/features associated with columns in PowerPivot.
This tip will cover the following topics:
- How to set Description for Columns in PowerPivot
- How to set and modify Column Data Types in PowerPivot
- How to apply formatting to Column Data in PowerPivot
- How to Show or Hide the Columns in PowerPivot
- How to Sort Data in one Column with Data in another Column in PowerPivot
To work through the steps outlined in this post, you need to set up your Excel/PowerPivot Workbook by following the steps outlined in the below listed posts in the same sequence specified.
- Importing SQL Server Data from Multiple Data Sources into PowerPivot for Excel
- Creating Linked Tables in PowerPivot for Excel
- Combining Data from Multiple Relational Data Sources into One Table in PowerPivot for Excel
To read the full article, go to this link: Working with Columns and Properties in PowerPivot for Excel.
Posted on March 15, 2013, in MS Excel, MS Office, Power Pivot, Self-Service BI, SQL Server and tagged Excel, Microsoft Excel, Microsoft SQL Server, MicrosoftBI, MSBI, PivotTable, Power Pivot, Self-Service BI, Spreadsheets. Bookmark the permalink. 1 Comment.