cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Mrooney Frequent Visitor
Frequent Visitor

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

 

Resources.png

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Sean Super Contributor
Super Contributor

Re: Use a column header as a slicer

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

View solution in original post

4 REPLIES 4
Highlighted
Sean Super Contributor
Super Contributor

Re: Use a column header as a slicer

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

View solution in original post

Mrooney Frequent Visitor
Frequent Visitor

Re: Use a column header as a slicer

I could kiss you!

Sean Super Contributor
Super Contributor

Re: Use a column header as a slicer

Smiley LOLSmiley LOLSmiley LOL

MEGHNA Visitor
Visitor

Re: Use a column header as a slicer

Hi I need help. My data is as below.

 

FunctionAdvisor 1Advisor 2Advisor 3
Death102030
Birth152535
Anniversary204050

 

My visual must first look like this

Image 1.jpg

 

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 😞

Image 2.jpg

 

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 54 members 859 guests
Please welcome our newest community members: