Forum Discussion

SnowPanda's avatar
SnowPanda
New Member
9 years ago

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...
Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

You could change your table into a 3 column table as one option

 

Col1 = StaffID

Col2 = Leave Type

Col3 = Leave Value

 

You can then easily create a slicer over Col2.

 

You can do this in your Query Editor using Append, or in DAX using the UNION.

 

Let us know which you prefer and we can give more detailed instructions.

SnowPanda's avatar
SnowPanda
New Member
9 years ago


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

  • Sean's avatar
    Sean
    Icon for Community Champion rankCommunity Champion
    9 years ago

    SnowPanda

    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: