Sorting in Power View

In a Power View sheet, you can sort data in tables, matrices, and bar and column charts. You can sort individual charts within multiples. You can sort numeric fields, such as Sales Amount, and non-numeric fields, such as Name.

Sort charts in Power View

Sort tables and matrices in Power View

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

Sort images in Power View

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 sorts by that column.

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

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

More about sorting images in Power View.

Top of Page

See Also

Power View and Power Pivot videos

Tutorial: PivotTable data analysis using a Data Model in Excel 2013

Power View: Explore, visualize, and present your data

Applies To: Excel 2013

Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Change language