Forum Discussion

Nash2Bos's avatar
Nash2Bos
Icon for Helper I rankHelper I
1 year ago
Solved

How to re-arrange column values in a matrix table

Hi all,  I have a table with a column, Environment with values (Dev, TE1, prod) When i put that column into a matrix table is comes up as Dev, Prod, TE1. How can i arrange it so TE1 is in the middl...
  • Sahir_Maharaj's avatar
    1 year ago

    Hello Nash2Bos,

     

    Can you please try to add a new column to your table with custom sort order values:

    EnvironmentSort = 
    SWITCH(
        'Table'[Environment],
        "Dev", 1,
        "TE1", 2,
        "Prod", 3,
        BLANK()
    )
    

     

    Power BI uses the Sort by Column feature to override the default alphabetical sorting of text fields.

     

    By creating a numeric sort column (EnvironmentSort), you can define any custom order you want.

     

    Hope this helps.

     

  • hnguy71's avatar
    1 year ago

    Hi Nash2Bos 

    An  easy way is if you can, you'd create a unique identifier number and then sort the column by it.  The index column can be done inside powerquery and then sorted in Power BI. For example,

    Then, after you've applied your changes, click sort by column: