The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
97 | |
80 | |
62 | |
57 |
User | Count |
---|---|
264 | |
120 | |
115 | |
83 | |
70 |