Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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?
Solved! Go to Solution.
@Anonymous , You can consider OLS
https://learn.microsoft.com/en-us/power-bi/enterprise/service-admin-ols?tabs=table
@Anonymous , You can consider OLS
https://learn.microsoft.com/en-us/power-bi/enterprise/service-admin-ols?tabs=table
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
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.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
76 | |
76 | |
55 | |
36 | |
34 |
User | Count |
---|---|
99 | |
56 | |
53 | |
44 | |
40 |