Forum Discussion

santoshransubhe's avatar
santoshransubhe
Regular Visitor
7 years ago
Solved

Dynamic Column Name Based on Slicer Selection

Here is the table I'd be working with: Name StatValue A         1 B         2 C         3 On the actual report, I'd like to have a slicer with the values "Col1" "Col2" "Col3" Once selection one...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    7 years ago

    santoshransubhe,

     

    Simply use a matrix visual, drag Table2[ColumnName] to Columns, measure below to Values.

    Measure =
SUM ( Table1[StatValue] )
santoshransubhe's avatar
santoshransubhe
Regular Visitor
7 years ago

Thanks. I checked the posts. I already have data in unpivot form. My problem is only with table header column which i want to rename based on slicer value. Any idea how to manipulate the table header using any functions?

v-chuncz-msft's avatar
v-chuncz-msft
Community Support
7 years ago

santoshransubhe,

 

Simply use a matrix visual, drag Table2[ColumnName] to Columns, measure below to Values.

Measure =
SUM ( Table1[StatValue] )