Forum Discussion
amalm
7 years agoHelper III
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?
Hi amalm,
I suggest to use RLS here. For more details, please check the online document.
Regards,
Frank
3 Replies
- v-frfei-msftCommunity Support
Hi amalm,
I suggest to use RLS here. For more details, please check the online document.
Regards,
Frank
- amalmHelper III
Thank you, I'll explore this.
- v-frfei-msftCommunity Support
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