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 of these values, I'd want it to populate the visual table with the correct column name.

For example, if I selected "Col1"

Name Col1
A          1
B          2
C          3

If I selected "Col3"

Name Col3
A          1
B          2
C          3

Note the data does not change and always comes from source column StatValue.

Thanks!

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

4 Replies