Custom sort on rows and columns in Power BI Matrix

Hi  Anonymous ,

I created some data:

Matrix visual object:

Custom rules:

Columns in the order of A-C-B-D

Lines are in the order of January – February – March – April

Here are the steps you can follow：

1. Enter the power query, select Add Column – Column From Examples – From All Columns.

First create [Column]

Then create [Row]:

Get the data:

2. Select [group], click Column tools – Sort by – [Column]

3. Select [Month], click Column tools – Sort by – [Row]

4. Result：

Best Regards,

Liu Yang

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