Export (0) Print
Expand All

Sorting in Power View

SQL Server 2012
Important note Important

Please visit the most up-to-date Power View documentation on office.microsoft.com. Power View is now a feature of Microsoft Excel 2013, and is part of the Microsoft SQL Server 2012 Reporting Services add-in for Microsoft SharePoint Server 2010 and 2013 Enterprise Editions.

In Power View, you can sort data in tables, matrices, and bar and column charts. You can sort the individual charts within small multiples. You can sort measures, such as Sales Amount, and non-measures, such as Name.

Note Note

Power View is a feature of SQL Server 2012 Reporting Services Add-in for Microsoft SharePoint Server 2010 Enterprise Edition.

You sort tables and matrices by clicking column headings. When you click a column heading, you see an up or down arrow showing the field is sorted in ascending or descending order.

In a flat table, you can sort on one column at a time.

In matrices, you can sort the whole matrix on one measure column, or sort the matrix on one non-measure column in each grouping level. For example in a matrix grouped by a Product Category column, with Product Subcategory and Average of Unit Cost columns, you could sort by the product category and the product subcategory fields.

Matrix sorted descending by product category and ascending by product subcategory

Matrix sorted by two non-measure coumns

Or you could sort by the average unit cost within each category. When you sort by the average unit cost, the product categories are sorted from largest to smallest category and the subcategories are sorted within each product category group.

Matrix with categories and subcategories sorted descending by average unit price.

Matrix sorted by a measure

Arrow icon used with Back to Top link Back to Top

You can sort chart categories by a category value (in the Axis box) or by a measure value (in the Values box). By default the chart is sorted ascending alphabetically by the category unless a sort order is specified in the model – for example, a month or weekday name field would be set to sort on another field, rather than sorting alphabetically.

Sort a chart

Chart sorted ascending on the Name category value by default

Chart sorted alphabetically
  1. Hover over the top edge of a chart until you see sort by in the upper-left corner, then the name of a field, and then either asc or desc.

  2. Click the field name to sort on a different value.

  3. Click asc or desc to sort in the opposite direction.

Chart sorted descending by the Qty Served measure

Chart sorted by measures

Charts that can be sorted

Some charts cannot be sorted. Others cannot be sorted as individual charts, but when used in small multiples, the multiples can be sorted.

Chart type

Can be sorted

Multiples can be sorted

Column

Yes

Yes

Bar

Yes

Yes

Line

No

Yes

Scatter or bubble

No

Yes

Stacked column or bar

Yes

Yes

100% stacked column or bar

Yes

Yes

Scatter or bubble with play axis

No

No

Arrow icon used with Back to Top link Back to Top

Power View cannot sort binary values like photos. Therefore it sorts by another column—which column is determined by settings in the model on which the report is based.

  • If the Sort by Other Column property is set, then Power View will sort by that column.

  • If not, but the table has a Default Label column set, then Power View will sort by that column.

  • If neither, then the image will sort by the Row ID field.

Arrow icon used with Back to Top link Back to Top

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft