cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
amalm Helper II
Helper II

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
Community Support

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 others find it more quickly.

View solution in original post

3 REPLIES 3
Community Support
Community Support

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 others find it more quickly.

View solution in original post

amalm Helper II
Helper II

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

Thank you, I'll explore this.

Highlighted
Community Support
Community Support

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 others find it more quickly.

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Top Solution Authors
Top Kudoed Authors