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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.