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.
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)
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |