Custom order or sort columns

[Snagalapur]

Hi All,

How to custom order below level1 columns in matrix, also i have 7 diffrent column levels in matrix.

Thank you.

[SamWiseOwl · Accepted solution]

Hi @Snagalapur 
In table view (3rd image) click on the column Level 1 and then on Column tools choose Sort By Column and select your Rank as the sort column.

Then in the front end on your matrix (2nd image) click the ... in the top right of your visual.
Choose sort and sort by Level 1 and Descending that should apply the sort.

[saud968]

Identify the Column Level:

Open the "Fields" pane in your Power BI report.
Locate the column level you want to customize (Level 1).
Create a Custom Sort Column:

Create a new calculated column in your data model.
Assign a numerical value to each category within Level 1 based on your desired order.
For example, if you want "Management Eval" to be first, "Non Trade Alliance" second, and so on, you could create a calculated column named "SortOrder" with values like 1, 2, 3, etc.
Sort the Column Level:

Right-click on the Level 1 column in the matrix visual.
Select "Sort by Column" from the context menu.
Choose the "SortOrder" column you created in step 2.
Set the sort order to "Ascending" to achieve the desired order.

Best Regards
Saud Ansari
If this post helps, please Accept it as a Solution to help other members find it. I appreciate your Kudos!

[SamWiseOwl]

Hi @Snagalapur 

You can assign a column to be sorted by another column.

Click the column, top of the page Column tools | Sort by column | Choose the column with your sortId

[Snagalapur]

I did create column order (back-end) and sorted based on the rank column but chages are not applied in matrix column (front-end). please suggest.

[SamWiseOwl · Accepted solution]

Hi @Snagalapur 
In table view (3rd image) click on the column Level 1 and then on Column tools choose Sort By Column and select your Rank as the sort column.

Then in the front end on your matrix (2nd image) click the ... in the top right of your visual.
Choose sort and sort by Level 1 and Descending that should apply the sort.

[Snagalapur]

thank you so much for your patience.

I was able to update sorting but as highlighted below there is mismatch with one record, although rank is 10 for Management eval.

[SamWiseOwl · Accepted solution]

That means it is treating 1 and 10 the same.

Normally happens when the datatype is set to text, change using Column Tools to Whole Number.

[Snagalapur]

Thank so much for help, Solution works :-).