Sorting in Power View

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 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: Import Data into Excel, and Create a Data Model

Power View: Explore, visualize, and present your data

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.