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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
sanjanarama
Resolver I
Resolver I

matrix display for heirarchy

I'm trying to display the heirarchy way to represent data, i have used path method , but im unable to display in visual

IDhirachynameparent IDglobal name
100Globalanullnull
101Globalbnullnull
102intermediatec101b
103countryd102c
104countrye105f
105intermediatef100a
106intermediateg105f



pathHeir = PATH(Sheet2[ID],Sheet2[parent ID])

want to display global ID and underneeth its heirarchy numbers.
1 ACCEPTED SOLUTION

In the matrix visual formatting pane go to Row headers and turn off stepped layout. That should give you the desired view.

View solution in original post

9 REPLIES 9
JirkaZ
Solution Specialist
Solution Specialist

You should just be able to put both columns (ID and Parent ID) into the same row field of the matrix visual. The hierarchy should be created automatically.

@JirkaZ 
I'm not getting desired result

sanjanarama_0-1643632903591.png

 




for example if i expand the matrix , it should look like this

100Globala  
 105Intermediatef 
  106intermediateg

sanjanarama_0-1643636330891.png


@JirkaZ 
this is how I am getting into

Seems to be correct

sanjanarama_0-1643636586801.png



but if you see 100 ID is parent of 105, and 105 is parent of 104 and 106.

so if 100 is expanded then 105 values should be shown and below that 104 and 106 respectively.

not as seperate entity
@JirkaZ 

In the matrix visual formatting pane go to Row headers and turn off stepped layout. That should give you the desired view.

sanjanarama_0-1643639546235.png



it worked, thank you I'm able to achieve for what i was looking for

@JirkaZ 
is it possible to remove empty spaces for level3 if the values are not present in that row

sanjanarama_1-1643725199123.png

 

In that case create a separate "Level" columns for Level 1, Level 2, Level 3 using the output of the PATH function. For Level 1 you should use PATHITEM(yourpath, 1) etc.
Then you'll have to create a hirearchy in your table (right click on Level 1 and select Create Hierarchy. Then add L2 and L3 to the same hierarchy.

 

Finally add this hierarchy to your matrix rows area.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

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.