Forum Discussion

Mrooney's avatar
Mrooney
Frequent Visitor
9 years ago
Solved

Use a column header as a slicer

Help this is driving me mad!   The powers that be are using a spreadsheet which shows project names along with timescales and then allocated hours per resource. The challenge is the resources are n...
Need Help
Tutorial Requests
  • Sean's avatar
    Sean
    9 years ago

    Mrooney

    1) Go to the Query Editor - select both Project Name and Timelines Columns - Transform tab - Unpivot Other Columns

    2) Rename Attribute column to Agent/Name (this will be your slicer Column) and Value column to Hours or sth...

    3) Home tab - Close & Apply

     

    Hope this helps! :smileyhappy:

Mrooney's avatar
Mrooney
Frequent Visitor
9 years ago

I could kiss you!

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

:smileylol::smileylol::smileylol:

  • MEGHNA's avatar
    MEGHNA
    Regular Visitor
    9 years ago

    Hi I need help. My data is as below.

     

    FunctionAdvisor 1Advisor 2Advisor 3
    Death102030
    Birth152535
    Anniversary204050

     

    My visual must first look like this

     

    I want a slicer with an option to choose the advisor group. Say I choose advisor group 1, the visual must change as below. Please help me :(