Filtering by Projects with Child Items in Same Table

[Anonymous]

Good morning,

I have a 'ProjectTable' like below:

ID	ProjectName	ParentProjectID
1	A	NULL
2	B	NULL
3	C	1
4	D	NULL
5	E	2
6	F	3
7	G	4
8	H	NULL
9	I	4
10	J	1

What I'd like to do, is utilize the Hierarchy Slicer so that I can easily choose a projects subproject. Ideally, the filter would like the below:

A

--> C

----> F

--> J

B

--> E

--> I

D

--> G

H

Something to keep in mind, is that there is no way for me to know how many or few levels down there can be.

Thanks for the help!

[v-piga-msft]

Hi @Anonymous,

It seems that you're looking for a way to achieve the Hierarchy for Parent child relationship.

Hope this blog Parent-Child Hierarchies will help you which introduce it in more details.

In addition, you could have a reference of  Parent and Child Functions (DAX).

Best Regards,

Cherry