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] )