cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
amalm Regular Visitor
Regular Visitor

Remove some Values from a Slicer to hide data for some users

Hi, My Power BI data is imported from various jobs: J001, J002, J003, etc. Each job has one excel sheet and one corresponding report in Power BI. There is another report called "All Jobs" that is simply a Union of the common columns of all these individual reports. All my visuals are calculated based on the data in the "All Jobs" table. As there is a column in this table mentioning the Job ID, I can filter results on a per-job basis using a slicer. Now the company is expanding, and there are multiple offices. I want to give access to certain offices to access the data for the jobs under their office only. An example would be: Office 1: J001, J003, J007 Office 2: J002, J005, J006 When the manager in Office 1 opens the report, the Job selection Slicer should show the only Jobs J001, J003 and J007 to choose from. Similarly for the manager in Office 2 who should see only J002, J005, and J007. Is there a way to do this easily?
1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Remove some Values from a Slicer to hide data for some users

Hi @amalm,

 

I suggest to use RLS here. For more details, please check the online document.

 

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
Community Support Team
Community Support Team

Re: Remove some Values from a Slicer to hide data for some users

Hi @amalm,

 

I suggest to use RLS here. For more details, please check the online document.

 

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

amalm Regular Visitor
Regular Visitor

Re: Remove some Values from a Slicer to hide data for some users

Thank you, I'll explore this.

Community Support Team
Community Support Team

Re: Remove some Values from a Slicer to hide data for some users

Hi @amalm,

 

Does that make sense? If so, kindly mark my answer as the solution to close the case please. Thanks in advance.


Regards,
Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 45 members 844 guests
Please welcome our newest community members: