Sorting by the last column

Hey there!

You could try creating a Sort Column in Power Query

• Since the matrix does not allow direct sorting by specific columns, create a calculated column:
• In Power Query, add a new column:
  SortColumn = 'YourTable'[2024] // Ensure this refers to the 2024 column

• Sort the Matrix Table Using This Column

  • Go to the Fields pane in Power BI.
  • Click on the Country column.
  • Select Sort by Column → Choose SortColumn.

• Ensure Sorting Order

  • If the sort is incorrect, adjust sorting in Visual Level Filters:
    • Click on the matrix table.
    • Under Sorting & Filtering options, select 2024 column → Sort Descending.

If sorting directly is not working, create a DAX measure to rank countries based on the 2024 values:

Then, sort the matrix by Rank2024 instead.

Hope this helps!

😁😁