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 :(

         

  • RobinStacpoole's avatar
    RobinStacpoole
    Regular Visitor
    5 years ago

    Hi Sean.  Thanks for your explanation, it solves the problem, but creates another.  You cannot use an unpivoted table to generate cross plots and slicer filters will only effectively act on a single measure taken from the tall-skinny data set.  How can you solve the problem without destroying this functionality?