cancel
Showing results for
Did you mean:

## Matrix visual sorting column

Hi all,

I have created a Matrix visual which has the datepart Year as column.

The year is sorted asc. It is possible to sort it desc?

Thanks.

1 ACCEPTED SOLUTION
Microsoft

Hi @Sebastian,

Based on my test, you should be able to follow steps below to sort Year column desc on Matrix visual.

1. Add a Year column to your table if you don't have it yet.

2. Use the formula below to create a new table, and create a relationship between the new table and your table with the Year column.

```Table = SUMMARIZE ( Table1, Table1[Year], "Reverse Year", - MAX ( Table1[Year] ) )
```

3. Sort "Year" column by "Reverse Year" column in the new created table.

4. Then you should be able to show the Year column from the new created table as Column in the Matrix to Order Yer desc.

Here is the sample pbix file for your reference.

Regards

5 REPLIES 5
Microsoft

Hi @Sebastian,

Based on my test, you should be able to follow steps below to sort Year column desc on Matrix visual.

1. Add a Year column to your table if you don't have it yet.

2. Use the formula below to create a new table, and create a relationship between the new table and your table with the Year column.

```Table = SUMMARIZE ( Table1, Table1[Year], "Reverse Year", - MAX ( Table1[Year] ) )
```

3. Sort "Year" column by "Reverse Year" column in the new created table.

4. Then you should be able to show the Year column from the new created table as Column in the Matrix to Order Yer desc.

Here is the sample pbix file for your reference.

Regards

That works really fine. Thank you very much 🙂

Microsoft

Hi @Sebastian,

Here is a similar thread in which a workaround is mentioned. Could you go to check if it helps in your scenario?

You cannot achieve  this reverse sorting directly... here is a workaround:

1. Go to the Edit Query option of the Week dim table.

2. Apply Sort desc on the unique week code column (there must be a unique identifier for each week i.e. in my case I have WeekCode column as 20170101, 20170102, 20170103, 20170104, 20170205, 20170206.... YYYYMMWW where WW is the incremental week number of the year from 1 to 52.

3. Select 'Add Index column'  from Add Column menu and provide Starting Index=1 and Increment=1 in the dialog box.

4. Rename column as appropriate.

4. Save Apply and Close the Edit Query

5. Use this Index as 'Sort By Column' wherever required.

Regards

thanks for your answer.I tried this way but the sorting is still the same.

Resolver II

Click the header of the column you will see an Arrow appear on the bottom left. Double clik on the header to change your sort order

Announcements

#### CollabDays Lisbon - 26 November 2022

Sessions include practical, hands-on experience that will help you take the next step in your career and know-how.

#### Difinity Conference 2022

Difinity is the largest Microsoft Data, AI, Power BI, Power Platform and Business Applications Conference in New Zealand.

#### European Share Point Conference

This conference returns live and in-person in Copenhagen this 28 November-01 December with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

#### Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Top Solution Authors
Top Kudoed Authors