Sorting matrix table

[Umidjon]

Hi, 

I am using Power Bi Desktop. I created matrix table. However, I couldn't sort specific column values ( descending order) in matrix table. In rows I have category and sub-category. While I put years to columns and quantity to values field. Do you know any solution for this.

Thanks in advance

[Anonymous]

Hi @Umidjon ,

You can select the matrix and make the setting as below screenshot:

Best Regards

[amitchandak]

@Umidjon , Suppose I have Year on column (pivot) 

Then create column like these 

Year 1=  [year]

year sort = rankx(All(Table), Table[Year],,desc,dense)

now sort year 1 on year sort and use Year 1 in visual (Year will circular dependencies, that is why year 1)

https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column

In case it is in row, there is option on three dots to sort descending

[Umidjon]

Hi, 

it is not working. I want to sort values in year 2020. How it can be done? Please help. It is important.

Thanks in advance