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

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