Forum Discussion
Order columns in a matrix
Hi
Here's how my column header looks like in the matrix, It's a matrix of team name and grade levels.
| Team name | 10 | 11 | 12 | 14 | 6 | 8 |
| Robert | 2 | 5 | 6 | 2 | 1 | |
| Jim | 4 | 6 | 1 |
I would like to order the column headers by ascending order.
I have tried adding an index column but that just landed me with numbers from 1 to 90(end of data set). How does my data know that that I'd like to add index relative to the Grade level and later sort by it?
I have also tried using conditional column. However with conditional columns I am not able to sort it in the matrix since ir renames by grade levels.
I have checked out the following links already -
https://community.powerbi.com/t5/Desktop/Matrix-Column-Head-Order/td-p/71572
https://community.powerbi.com/t5/Desktop/Matrix-Month-Column-Wrong-Order/m-p/1450455
https://community.powerbi.com/t5/Desktop/Custom-Matrix-Column-Order/m-p/1212350
- Anonymous5 years ago
saipawar is the "Sort by column" on Grade Level set to sort by itself?
Also, what is the data type of the "Grade Level" column?