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

View solution in original post

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

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors