Conditional Display of Slicers Based on RLS in Power BI / Fabric

[syl-ade]

Hi All,

Is it possible to conditionally show or hide a slicer based on the user’s RLS role or permissions? For example, a manager should see the slicer to choose an employee, while a regular employee should only see their own data without that slicer.

Has anyone implemented something similar or found a workaround? Any guidance or best practices would be greatly appreciated!
Thanks in advance!

[v-tejrama]

Hi @syl-ade ,

Thank you for your question about showing or hiding slicers based on user roles or permissions in Power BI. At this time, Power BI does not have a built-in feature to dynamically show or hide slicers based on RLS roles. The most practical and recommended way to handle this is by using Row-Level Security to control what data appears in the slicer. This way, managers will see the full list of employees, while regular employees will only see their own name, which effectively limits their choices without needing to hide the slicer itself. This approach is straightforward to implement, secure, and provides a clear user experience without relying on more complicated solutions like bookmarks or page navigation.

If it is absolutely necessary to hide the slicer visual completely, it can be done using bookmarks and navigation based on roles, but that method tends to be more complex and may make the report less intuitive to use. Overall, tailoring the slicer data with RLS is the best practice in terms of ease of maintenance, security, and reliability. I would be glad to assist you in setting up the RLS roles and the required measures if you would like to move forward with this approach.

Best Regards,
Tejaswi.
Community Support

[v-tejrama]

Hi @syl-ade .

I wanted to follow up and see if you had a chance to review the information shared. If you have any further questions or need additional assistance, feel free to reach out.

Thank you.

[v-tejrama]

Hi @syl-ade ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Thank you.

[danextian]

Hi @syl-ade 

If what you're trying to do is to dynamically change the visibitlity of a visual based on RLS, that isn't currenlty supported. RLS affects the visible rows but the not the visbility of the visuals. So in essence, the employee would still the slicer but only his/her name should appear in the selection.

[grazitti_sapna · Accepted solution]

Hi @syl-ade,

You can create a role mapping table like this,

UserEmail	Role
manager@ company.com	Manager
employee1@company.com	Employee
employee2@company.com	Employee

And then to check user role create a measure like this 

User Role =
VAR _email = USERPRINCIPALNAME()
RETURN
LOOKUPVALUE(UserRole[Role], UserRole[UserEmail], _email)

Now Create a measure to apply filter 
Show Employee Slicer = IF([User Role] = "Manager", 1, 0)

Create a card visual or transparent shape with custom message

Add this on top of the employee slicer

Use the Show Employee Slicer measure in the visual-level filter of that shape:

Filter condition: Show Employee Slicer = 0

🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!

[KarinSzilagyi]

Hi @syl-ade, there currently isn't any function to conditionally show or hide slicers (unfortunately). The good news is that if you apply RLS on the column used in the slicer, it will at least only show their own name to the employees (though I know that isn't quite the answer you were hoping for). You could also add a filter-measure to the slicer which would still display it but disable it overall.