Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
88 | |
70 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |