Dynamic Slicer Value based on the Role assigned to a user

Question

Hi All,&nbsp;Can anyone please let me know whether it is possible to set the default value of a slicer based on the Roles created in Power BI report.&nbsp;For Example, We have a year slicer in a report. The default value of that slicer should be varied according to the role of that particular user accessing the report.&nbsp;Roles&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Default Year ValueRole 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2016Role 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2017Role 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2018Role 4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2016.&nbsp;Please let me know whether it is possible or not.&nbsp;&nbsp;&nbsp;

anonymous · Answer

Hello,&nbsp;I suppose you want row level security? you can refer to:&nbsp;https://docs.microsoft.com/en-us/power-bi/service-admin-rls#targetText=Row%2Dlevel%20security%20(RLS),to%20datasets%20in%20the%20workspace.&nbsp;Best Regard!

amir851 · Answer

Thank you for your reply.&nbsp;I am aware of how to create a role in Power Bi Desktop. My issue is that based on those roles the default value in the slicers present in the report should vary according to table mention in my question.

v-chuncz-msft · Answer

Amir851&nbsp;
&nbsp;
Here is a similar case for your reference.
https://community.powerbi.com/t5/Developer/RLS-vs-Filter-for-current-user/m-p/329584#M9750

Forum Discussion

Dynamic Slicer Value based on the Role assigned to a user

3 Replies

Related content

Show slicers dynamically

Power BI Dynamic Filter/Slicer

Dynamic Complex Filtering with slicers

Dynamic Date Slicer

Dynamic Subtitle with Hierarchy Slicers