Forum Discussion

amalm's avatar
amalm
Helper III
7 years ago
Solved

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?

3 Replies

    • amalm's avatar
      amalm
      Helper III

      Thank you, I'll explore this.

      • v-frfei-msft's avatar
        v-frfei-msft
        Community 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