Forum Discussion
Change table data with slicer
So, I have a table like this: Player Number Shots Shots on target Pressures Recoveries Key Passes Assists Player 1 0 0 1 0 1 1 Player 2 2 1 2 1 0 0 Player 3 1 1 ...
ChiragGarg2512
Solution Sage
Solution SageThis can be done with the help of two slicers.
Step 1: Go to Power Query.
Step 2: Select three columns, i.e, shots, pressure and passes. and unpivot them. Do the same with the remaining 3 columns. This will create a 5 column table on PowerQuery with 2 attribute columns and 2 value Column with Player Number.
Step 3: Save the changes.
Step 4: The three columns to be displayed in table should be Player Number, Value, Value1. Two slicers where one has Attribute and another with Attribute1.
Step 5: Selecting 2 columns from slicers will give the desired result.