Sort each column in matrix independences other columns

[Someone22]

Hello,

Could you please support me?

I have a matrix in Power Bi, which is show the changes of materials.

Currently i have 6 months, July, August, September, October, November, December. The months are dynamic, every cases(date of update) includes 6 months, the intervall change in every next month, so in July the first month will be 2025.August and the last months will be 2026.January. Month is a date format.

So, what i would like to do: sort any column independent the others

for example:

I want to see the TOP increasing in "2025. szeptember" column independent the other columns, but i can not sort any month column, only just the Total column. So, the result what i would like to see is, if i sort descending "2025. szeptember" column, in that column see the decreasing list from the biggest value to the lowest, but in the other column i just see the changes which are not sorted.

For example with values:

Material  2025.július   2025.augusztus   2025.szeptember 2025.október 2025.november 2025.december

A                 100                   200                       800                     150               130                     300

B                  -50                   -100                     750                      50                 80                      900

C                 600                   120                       700                      90                 170                     40

Is that possible to do that? It have to be dynamic, the intervall of month change in every next month.

Thank you in advance!

[mark_endicott]

@Someone22  - the only way to acheive this would be to create a measure for each month, but then your matrix will not be dynamic. 

If I answered your question please mark my post as the solution, it helps others with the same challenge find the answer!

[Rupak_bi]

Hi @Someone22 ,

In matrix, you cannot sort columns. But in table, you can. What you need to do....

1. Make 6 different measure. name like month 1, month 2  ......month 6.

2. the dax will be like 

       month1 = calculate(sum(table,value), table,month = month(today())+1)

       month1 = calculate(sum(table,value), table,month = month(today())+2)...........like this

the drawback will be the month name cannot be seen.