Locking down slicer based on job role and location

[AmyD]

I have a report which details data for the entire business. My slicer allows the user to filter on their location/region.

Is there a way to set it so that the manager of a particular location can only see the slicer data for their location, or regional manager to only see the data for their region?

I am planning to publish this to SharePoint for them to access.

Many thanks

[Bmejia · Accepted solution]

look into Row level security, make sure you read this section, "Using RLS with workspaces in Power BI" , Roles will only work if they have viewer roles in the workspace if you need it to work propertly at least,  any other role will still give them access to viewing the rest of the other data. 

https://learn.microsoft.com/en-us/fabric/security/service-admin-row-level-security