Dynamic Column Name Based on Slicer Selection

[santoshransubhe]

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!

[PattemManohar]

@santoshransubhe Please have a look into below posts... might help for the scenario you are after...

https://community.powerbi.com/t5/Desktop/Column-Selection-in-matrix-table-visualization/m-p/547264#M...

https://community.powerbi.com/t5/Desktop/filtering-fields-to-show/m-p/566713#M267403

[santoshransubhe]

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 · Accepted solution]

@santoshransubhe,

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

Measure =
SUM ( Table1[StatValue] )

[Greg_Deckler]

I am not aware of a way to do that.