Forum Discussion

amalm's avatar
amalm
Icon for Helper III rankHelper 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
      Icon for Helper III rankHelper III

      Thank you, I'll explore this.

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