Matrix table - Row Header

[gauravnarchal]

Hello

I am using a matrix table and want to know if there is a way to rename the row headers?

Instead of 1, I want to show Ship and instead of 3, I want to show Return.

Thanks

[Anonymous · Accepted solution]

Hi @gauravnarchal 

The screenshot you provided seems to be column names, not row names .

(1)If you want to change the column name ,you can rename the field directly in Fields .

(2)If you want to change row names ,you can create a column to replace the original value in [Transaction Type] and then add the column in Rows in visual.

Column = SWITCH(TRUE(),Table[Transaction Type]=1,”Ship”, Table[Transaction Type]=3,”Return")

Best Regards

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Samarth_18]

Hi @gauravnarchal 

you can create a column with below condition and use it as row in your matrix

column = if(table[shiporreturn] = 1,"Ship",if(table[shiporreturn] = 3,"Return"))

Thanks