Filter Rows

Power Query allows filtering by:

• Text
• Number
• Date
• Blank/null values

Example:

Keep only:

City = Sirsa

or:

Sales > 50,000

Sort Rows

Sort:

• Ascending
• Descending

Multiple sorting conditions can also be applied.

Practice

From the sales dataset:

1. Keep only 2026 records.
2. Remove blank customers.
3. Keep Sales > ₹10,000.
4. Sort Sales from largest to smallest.