Sorting data in Power BI - Cell-by-Cell Formula Trace

Sample Data

This table shows sales numbers for different fruits.

Cell	Value
A1	Product
B1	Sales
A2	Apples
B2	150
A3	Bananas
B3	120
A4	Cherries
B4	180
A5	Dates
B5	90

Formula Trace

SORT(Table1, Table1[Sales], DESC)

Step 1: Table1[Sales]

Step 2: Sort sales values descending

Step 3: Reorder rows based on sorted sales

Cell Reference Map

    A        B
1 Product  Sales
2 Apples   150
3 Bananas  120
4 Cherries 180
5 Dates    90

Arrows: Sorting uses column B (Sales) to reorder rows.

The formula sorts the table rows by the Sales column values in descending order.

Result

    A        B
1 Product  Sales
2 Cherries 180
3 Apples   150
4 Bananas  120
5 Dates    90

The table is sorted so the fruit with the highest sales (Cherries) is first, and the lowest (Dates) is last.

Sheet Trace Quiz - 3 Questions

Which product has the highest sales after sorting?

A Cherries

B Apples

C Bananas

D Dates

Key Result

SORT(table, column_to_sort_by, order) sorts table rows by the specified column in ascending or descending order.