AD group and resource hierarchy

[MalyMajo]

Hello all,

I have tabular data, which includes list of resources and the groups to which they belong.

Is it possible to format the data somehow to always show the structure when a resources is filtered?

Index	Level	Value
1	Level1	ProjectName_All
2	Level2	ProjectName_Team1
3	Level3	ProjectName_Team1_Offshore
4	Level4	peter.pan
5	Level3	ProjectName_Team1_Onshore
6	Level4	peter.parker
7	Level4	tony.hawk
8	Level2	ProjectName_Team2
9	Level3	ProjectName_Team2_Offshore
10	Level4	kendrick.lamar
11	Level4	tony.stark
12	Level4	slim.shady
13	Level4	cristiano.ronaldo
14	Level4	lionel.messi
15	Level4	alexander.ovechkin
16	Level3	ProjectName_Team2_Onshore
17	Level4	tony.hawk

So for example if I would filter tony.hawk, I would like to see following table:

Index	Level	Value
1	Level1	ProjectName_All
2	Level2	ProjectName_Team1
5	Level3	ProjectName_Team1_Onshore
7	Level4	tony.hawk
8	Level2	ProjectName_Team2
16	Level3	ProjectName_Team2_Onshore
17	Level4	tony.hawk

Please note, that resources can be in multiple teams. Additionally, resources does not necessary need to always be on "Level4". It can be anything between Level3 and Level6. 
Naming convention of groups is always same - in each case it starts with "ProjectName".

[BA_Pete]

Hi @MalyMajo ,

To filter like this in Power Query, you would do the following:

Table.SelectRows(
    previousStep,
    each [Value] = "tony.hawk" or Text.Contains([Value], "ProjectName")
)

Pete

[MalyMajo]

Actually, the project name never contains "ProjectName", it was just an example.

What I want to achieve is to see the hierarchy. So if I filter Tony Hawk, I want to see under which hierarchy he belongs.