Forum Discussion
Catrice
3 years agoAdvocate I
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...
- 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.
Catrice
3 years agoAdvocate I
thanks a lof for very detailled and well description