Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Solved! Go to Solution.
Simply use a matrix visual, drag Table2[ColumnName] to Columns, measure below to Values.
Measure = SUM ( Table1[StatValue] )
@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
Proud to be a PBI Community Champion
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?
Simply use a matrix visual, drag Table2[ColumnName] to Columns, measure below to Values.
Measure = SUM ( Table1[StatValue] )
I am not aware of a way to do that.
User | Count |
---|---|
98 | |
90 | |
78 | |
72 | |
65 |
User | Count |
---|---|
114 | |
98 | |
96 | |
68 | |
67 |