Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

Important: In Excel for Microsoft 365 and Excel 2021, Power View is removed on October 12, 2021. As an alternative, you can use the interactive visual experience provided by Power BI Desktop, which you can download for free. You can also easily Import Excel workbooks into Power BI Desktop

In Power View you can sort a table or matrix to display your data in the order you want. You can instantly reorder your data by sorting the table or matrix on any of its columns (except image columns).

Note:  If you are sorting in Power View in SharePoint, you must be in Editing Mode. In the table or matrix you want to sort, click Edit Report in the upper left of the report area.

Power View in SharePoint Enable Editing button

  1. In the table or matrix, click the column headings you want to sort. You see an up or down arrow next to the heading showing that the field is sorted in ascending or descending order.

    Sort Icon for Matrix in Power View

  2. Click the arrow to reverse the sort order. You can sort text, numbers, dates, and times. You cannot sort image columns.

    Power View Table Sorted

    Notice there are no arrows next to Gender or Count of Medal. Gender is using its default sort order, alphabetical. Count of Medal, a value field, is not being sorted in this view.

  3. In matrices, you can sort the whole matrix on one numeric column, or sort the matrix on one non-numeric column in each grouping level. Suppose you have a matrix grouped by Sport, with Discipline, Event, and Year Count columns. You can sort by just the Year Count column or you can sort by one or more of the other 3 fields (Sport, Discipline, Event) based on the order they appear in the matrix.

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

    The matrix below is sorted by Count of Year. If you sort by the count of the years the event has been played, the matrix is sorted from the Sport with the most years played to the least years played. And within Sport, Discipline is also sorted from the most years to the least years, and then alphabetical for Disciplines with matching totals.

    Excel matrix sorted by Year

    And this matrix is sorted by Discipline.

    Power View Matrix sorted by Category

Top of Page

See Also

Sort a chart in Power View

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

Top of Page

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×