Hide column from Hierarchy

[sarveshpandey23]

The hierarchy is of level 6. Level 1 can see the whole data which is working but the issue rises when a level 2 person logs in.

Theoritically, it can see the data of Level 2 and upto 6 but it can't see Level 1 data.

I tried making report for each level by removing a level from Filter.

I can see data but its completely wrong.(in 2nd pic with only two levels)

Is it possible to hide those columns from the report? It should be present in each level report but they are hidden.

Dax Query is use to create the Hierarchy:

Path = PATH(mstbl_UserRoleMapping[bigintMapId],mstbl_UserRoleMapping[bigintParentId])

pathitem = LOOKUPVALUE(mstbl_UserRoleMapping[varSupervisor],mstbl_UserRoleMapping[bigintMapId],PATHITEM(mstbl_UserRoleMapping[Path],2,1))

Level 1 = PATHITEM(mstbl_UserRoleMapping[Path],1)

Level 2 = PATHITEM(mstbl_UserRoleMapping[Path],2)

Level 3 = PATHITEM(mstbl_UserRoleMapping[Path],3)

Level 4 = PATHITEM(mstbl_UserRoleMapping[Path],4)

Level 5 = PATHITEM(mstbl_UserRoleMapping[Path],5)

Level 6 = PATHITEM(mstbl_UserRoleMapping[Path],6)

Table Cross section from where hierarchy is created with it IdHierarchy table

After removing above levels i got this.

[v-chuncz-msft]

@sarveshpandey23 

You may implement Row-level security and try Matrix visual.

https://community.powerbi.com/t5/Desktop/How-to-hide-null-columns-in-matrix-table/m-p/562296#M265307