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 not in a column called resources but individual columns with hours underneath. Screenshot below

 

I presumed the way to go would be to create a separate tablet with the resource names in and link a relationship to the corresponding column but that didn't work. 

 

The goal here is to have a slicer allowing you to select say 'Toby' and it will show the projects he's working on and for how many hours

 

Hopefully I'm missing something really obvious...

 

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:

5 Replies

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

      • Sean's avatar
        Sean
        Community Champion
        9 years ago

        :smileylol::smileylol::smileylol:

    • 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?