matrix display for heirarchy

[sanjanarama]

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

ID	hirachy	name	parent ID	global name
100	Global	a	null	null
101	Global	b	null	null
102	intermediate	c	101	b
103	country	d	102	c
104	country	e	105	f
105	intermediate	f	100	a
106	intermediate	g	105	f

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

want to display global ID and underneeth its heirarchy numbers.

[JirkaZ]

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.

[sanjanarama]

@JirkaZ 
I'm not getting desired result

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

100	Global	a
	105	Intermediate	f
		106	intermediate	g

[sanjanarama]

@JirkaZ 
this is how I am getting into

[JirkaZ]

Seems to be correct

[sanjanarama]

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 

[JirkaZ · Accepted solution]

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

[sanjanarama]

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

[sanjanarama]

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

[JirkaZ]

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.