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:

Sean's avatar
Sean
Community Champion
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
    Community 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 :(