Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Hide column data for particular users

I have a a slicer that allows users to filter by gender. I would like to have it where only certain people can see the gender slicer based on security setup. Is this possible? I tried a couple things but its not working yet. 

 

I tried adding row level by putting in [Gender] = "Value"'

 

I also tried Object security by changing the default object security under gender to None. But it still didnt get rid of the slicer just ended up making all my data blank when I switch to the view as. 

 

Any ideas on this? 

Need Help
Tips and Tricks

3 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Thank you amitchandak 


      So here is what I see at this point. I have it step by step on the error I get. When I change the gender object security to none, the slicer goes away which is great, but then all by data goes blank and I cant figure out why becuase none of my data is using the gender column. Only the table. 

       

      Result 

       

      Step 2

       

       

      Step 1

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        I figured it out. I was going into tables and finding the column but I needed to go to Roles and then click the role, then click on the table under it. Then click OLS column permissions and find the column. Then change column to None.