Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

how to create dynamic multiple column name in matrix?

Hi experts, I created a multiple dimension matrix, my solution is first created in dimension table and then use the switch true DAX get the revelent measure: 1.dimension table I created: 2.me...
Need Help
Show and Tell
  • AllisonKennedy's avatar
    AllisonKennedy
    2 years ago

    Anonymous  there's no way to change the column name dynamically. You can change it to a . so that 'year_name' doesn't display on your matrix. You can also use the 'Title' of the matrix or the 'subtitle' of the matrix (in the formatting for the matrix) to display the Years selected in your slicer. 

     

    To do that, click on the 'fx' in the title or subtitle formatting, then add a measure. Try a measue such as: 

    [fx Matrix Title selected Years] = CONCATENATEX ( VALUES( TableName[YearColumnNameUsedInSlicer] ), TableName[YearColumnNameUsedInSlicer] , ", " )

     

     

AllisonKennedy's avatar
AllisonKennedy
Icon for Community Champion rankCommunity Champion
2 years ago

Anonymous  there's no way to change the column name dynamically. You can change it to a . so that 'year_name' doesn't display on your matrix. You can also use the 'Title' of the matrix or the 'subtitle' of the matrix (in the formatting for the matrix) to display the Years selected in your slicer. 

 

To do that, click on the 'fx' in the title or subtitle formatting, then add a measure. Try a measue such as: 

[fx Matrix Title selected Years] = CONCATENATEX ( VALUES( TableName[YearColumnNameUsedInSlicer] ), TableName[YearColumnNameUsedInSlicer] , ", " )