Skip to main content

How to do a multi-column sort on a visual in Power BI?

Table of Contents

Step-by-Step Guide: Multi-Column Sorting in Power BI

  1. Select the Visual:
    • Click on the visual (e.g., table, chart, etc.) that you want to sort.
  2. Sort the First Column:
    • Click the header of the column you want to sort first.
    • The data will be sorted either in ascending or descending order.
    • An arrow will appear next to the column header to indicate the sort direction (up for ascending, down for descending).
  3. Sort by More than One Column (with Shift):
    • While holding the Shift key on your keyboard, click the header of the second column you want to sort by.
    • The data will now be sorted by:
      • The first column as the primary sort key.
      • The second column as the secondary sort key.
    • The sort direction for the second column will match your click (ascending or descending).
  4. Add More Sort Columns (Optional):
    • You can continue holding the Shift key and click additional column headers to sort by more columns.
    • The order in which you click the columns determines the sorting priority (first clicked column has the highest priority, second clicked column has the next priority, and so on).

Add comment