Forum Discussion

sarveshpandey23's avatar
sarveshpandey23
Frequent Visitor
6 years ago

Hide column from Hierarchy

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.