Forum Discussion
Dynamic Hierarchy Slicer based on RLS
- 1 year ago
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
Hey SreeniBattula ,
you can start here: https://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bi
Hopefully, this will help you tackle your challenge.
Regards,
Tom