Forum Discussion
Dynamic Hierarchy Slicer based on RLS
Hi SreeniBattula ,
Thank you for reaching out to us on the Microsoft Fabric Community Forum.
This is actually a common challenge in Power BI getting slicers to show only the part of the hierarchy that a user is allowed to see under RLS. While there is a way to do it using dynamic hierarchy tables, it's not straightforward and does require some fairly advanced modeling.If you haven’t already, I’d suggest sharing this on the Power BI Ideas forum. It’s definitely a feature that would make things a lot easier for scenarios like this, where we want slicers to fully respect RLS and only show relevant people in the hierarchy.
Appreciate if you could share the feedback on our Fabric Ideas - Microsoft Fabric Community Which would be open for the user community to upvote & comment on. This allows our product teams to effectively prioritize your request against our existing feature backlog and gives insight into the potential impact of implementing the suggested feature.If this post was helpful, please give us Kudos and consider marking Accept as solution to assist other members in finding it more easily.
Best Regards,
Menaka.
Community Support Team
Hi SreeniBattula ,
Thanks for reaching out to the Microsoft fabric community forum.
Fixed levels like L1, L2, L3 don't adapt dynamically based on the RLS context, which is why managers still appear in the slicer even though their data is excluded.
Please go through the below document:
Dynamic Row-Level Security (RLS) in Power BI with Organizational Hierarchy Explained - Power BI Docs
If this post was helpful, please give us Kudos and consider marking Accept as solution to assist other members in finding it more easily.
Best Regards,
Menaka.
Community Support Team
v-menakakota , Thanks for the solution link. i am already aware of the above given solution in the above link. it won't solve my issue. i have to hide the mangers in the the slicer.