Forum Discussion
Slicer
Greetings to all. I need help, can I construct a slicer by using header instead of column? I have a table that comprise of 7 Columns, first column contains staff ID while the rest contain values...
First of all thank you for your reply previous. This is my example of table, I want to make the header (AL, EL, ML, LC, UL, MIA) as slicer instead of the staff ID
In the Query Editor => select both Staff ID and Staff Name columns => Transform tab => Unpivot Other Columns
Rename the new Attribute and Value columns with appropriate names
(double clck on the column names or right-click and select rename)
the Home tab => Close & Apply
now you can use the Attribute (or whatever new name you have given this column) as your Slicer
Good Luck!:smileyhappy: