Forum Discussion

Catrice's avatar
Catrice
Icon for Advocate I rankAdvocate I
3 years ago
Solved

rename a column header in matrix visual when column represents column value of underlying datatable

Hi, how can I rename a column header in a matrix visual (or alternatively create a new column within matrix visual) when the column header represents a column VALUE (but not a column itself!) of the...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    3 years ago

    Hi Catrice 

     

    You need to have the new column names in a column. You can add a new table similar to below 'Dim Status' which has new status names in a column and the corresponding old names in another column. Create a relationship between two tables on the common [Status] column, with 'Dim Status' filtering the original table. 

     

    Then use 'Dim Status' table's [Status Name] column (the new name column) in the matrix visual as Column field. 

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.

     

v-jingzhang's avatar
v-jingzhang
Icon for Community Support rankCommunity Support
3 years ago

Hi Catrice 

 

You need to have the new column names in a column. You can add a new table similar to below 'Dim Status' which has new status names in a column and the corresponding old names in another column. Create a relationship between two tables on the common [Status] column, with 'Dim Status' filtering the original table. 

 

Then use 'Dim Status' table's [Status Name] column (the new name column) in the matrix visual as Column field. 

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.