Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Slicer with Individual & Grouped Selection

Hi all,

 

I have a list of people that I am using as a slicer for some visuals:

 

PersonGroup
JimNone
BobNone
SusanNone
FredNone
MoNone
GregNone
LucyReporter
SandraReporter
AbidReporter
NadiaReporter
TomNone

 

This is a standalone table that is to be linked to a table called VizData. What I want to do is to have all the individual entries in the 'Person' column as selectable slicers, but also for users to be able to select the 'Reporter' group and see Lucy, Sandra, etc. as an amalgamated group (but still be able to select the four in the 'Reporter' group as an individual if they wish). I do not need to create a 'None' group.

 

I'm struggling to work out how to do this - can anyone suggest a method?

 

TIA,

 

SamB

2 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi,

       

      I didn't know about the hierarchy slicer - does exactly what I was after. Many thanks!

       

      Sam