Forum Discussion
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.
1 Reply
- v-chuncz-msftCommunity Support
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