Boss/employee segmenter

It would be so, the first table is the table of facts. It contains the event number, the code of the person who classifies it, classification status, the research number (which coincides with the event number), the code of the person who investigates it, the status of the research, the action code (several actions can be derived from an investigation), the code of the person who must perform it and the status of the action. A person may have to classify, investigate or perform an action. The second table has the codes of each user, the name and the code of their boss. In the example case it is a linear chain: So-and-so is the boss of So-and-so and So-and-so is the boss of Pepito. What I want to achieve is a visual with events and research (since they have the same code) and a visual one with the actions. And put a person in the slicer. So if I put So-and-so I should see all the data of the tasks. If I put Menganito I should see the data of Menganito and Pepito's tasks. If I put Jiminy to see Jiminy's data alone because he has no subordinates.