Forum Discussion

saipawar's avatar
saipawar
Icon for Helper IV rankHelper IV
5 years ago
Solved

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 name1011121468
Robert2 5621
Jim 4 61 

 

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 

 

  • Anonymous's avatar
    Anonymous
    5 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?

     

     

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    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?

     

     

    • saipawar's avatar
      saipawar
      Icon for Helper IV rankHelper IV

      Anonymous You are absolutely right. The data type was text!! I changed it to Whole number and the matrix got sorted!! 

       

      Thanks