Forum Discussion
Helper IVCustom order or sort columns
Hi All,
How to custom order below level1 columns in matrix, also i have 7 diffrent column levels in matrix.
Thank you.
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.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.
7 Replies
- SamWiseOwl
Super User
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
SnagalapurI 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
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
Memorable Member
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!
