Use a column header as a slicer

[Mrooney]

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...

[Sean · Accepted solution]

@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!

[RobinStacpoole]

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?

[Mrooney]

I could kiss you!

[Sean]

[MEGHNA]

Hi I need help. My data is as below.

Function	Advisor 1	Advisor 2	Advisor 3
Death	10	20	30
Birth	15	25	35
Anniversary	20	40	50

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 😞