Forum Discussion
Nash2Bos
Helper I
1 year agoHow 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...
- 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.