Forum Discussion
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!
Simply use a matrix visual, drag Table2[ColumnName] to Columns, measure below to Values.
Measure = SUM ( Table1[StatValue] )
4 Replies
- PattemManoharCommunity Champion
santoshransubhe Please have a look into below posts... might help for the scenario you are after...
https://community.powerbi.com/t5/Desktop/filtering-fields-to-show/m-p/566713#M267403
- santoshransubheRegular Visitor
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-msftCommunity Support
Simply use a matrix visual, drag Table2[ColumnName] to Columns, measure below to Values.
Measure = SUM ( Table1[StatValue] )
- Greg_DecklerCommunity Champion
I am not aware of a way to do that.