Table & Matrix Combo

Hi,

Drag the first 5 columns to the row well of the matrix visual.  Drag Year and Month name from the Calendar Table to the Column well of the matrix visual.  To sort, specific columns/fields, click on the first column you want to sort and then with e Shift key pressed, click on the others columns which you want to sort by.

Hi meiwah 
If I understood you correctly the problem, is that there is no option to sort rows inside matrix columns. 
For example, you can't sort the rows by sales of January,  I don't think we have the needed functionality/workarounds to solve it.
Only to create a measure for every month.

We have an idea about this issue please vote for it:

https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=10822e38-2f28-ec11-b76a-281878bd589b

I voted 🙂
Also, you can check the add-ins like Inforiver / zebra.

https://inforiver.com/matrix/

https://zebrabi.com/power-bi-custom-visuals/

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly