Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric certified for FREE! Don't miss your chance! Learn more

Reply
Anonymous
Not applicable

Hierarchy Level Visual

I have a table with two fields : Project Manager and Projects

Each Project Manager has multiple projects.

 

Is there any visual in PowerBi where I can show this hierarchy i.e If I expand the Project Manager I get the list of Projects managed by him/her?

 

My data is like:

 
A -> project 1
A -> project 2
A -> project 3
A -> project 4
B -> project 6
B -> project 7
B -> project 8
C -> project 9
C -> project 10
C -> project 11
C -> project 13
C -> project 14
C -> project 15

 

Thanks in advance

 

 

 

1 ACCEPTED SOLUTION

You can use Matrix Visual and then use the expand/collapse option from there

 

Expand & Collapse Matrix Row Headers in Power BI - CloudFronts







Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!

Proud to be a Super User!




View solution in original post

3 REPLIES 3
FarhanAhmed
Community Champion
Community Champion

Add multiple fields to a hierarchy slicer - Power BI | Microsoft Docs







Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!

Proud to be a Super User!




Anonymous
Not applicable

@FarhanAhmed 

I do not want it in a slicer. I need a proper visual for the same

You can use Matrix Visual and then use the expand/collapse option from there

 

Expand & Collapse Matrix Row Headers in Power BI - CloudFronts







Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!

Proud to be a Super User!




Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.