Forum Discussion

SreeniBattula's avatar
SreeniBattula
Helper II
1 year ago
Solved

Dynamic Hierarchy Slicer based on RLS

Is there a workaround to display a hierarchy slicer in Power BI that shows only the selected user and their subordinates, while excluding users higher up in the hierarchy — particularly in a Row-Leve...
  • v-menakakota's avatar
    v-menakakota
    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