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.
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.
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.