Forum Discussion

PaulTrower's avatar
PaulTrower
Frequent Visitor
3 years ago

Line Manager Tree

Hi, I've seen a few posts relating to this topic but none which seem to lay it out in baby steps for a newbie like myself.   I have a staff data table with Employee and Line Manager columns.   Wh...
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi PaulTrower ,

 

You want to implement a selection of users in the slicer and filter out all users at that level of that user, right?

This requires you to create a separate user table, and then create a measure to filter as visual-level filters.

For example,

the field of the slicer is from Table 2 created  by dax.

Put the measure below into the visual-level filters and set up show items when the values is 1.

Measure = VAR _SEL=SELECTEDVALUE('Table 2'[User])
VAR _LEVEL=CALCULATE(MAX('Table'[Level]),FILTER(ALL('Table'),[User]=_SEL))
RETURN IF(MAX('Table'[Level])=_LEVEL,1)

 

You can download the attachment for more details.

 

 

   

                                                                                                                                                         

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

  • PaulTrower's avatar
    PaulTrower
    Frequent Visitor
    3 years ago

    Hi, thanks for your answer but not quite what I am after.

     

    I would like a slicer of all people that are managers, but some people are managers of managers.

     

    When I click on the slicer for 'Tom' I would like to see 'Abdul' and 'Hazel' in a matrix chart because Tom manages Abdul and Hazel.

    Jenny manages Tom and Joan (Joan manages Eric).

    When I click on Jenny I would like the matrix to show lines for Tom, Abdul, Hazel, Joan and Eric.

    Does that make sense?

    Thanks again for replying.