The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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.
User | Count |
---|---|
85 | |
84 | |
36 | |
34 | |
31 |
User | Count |
---|---|
92 | |
79 | |
66 | |
55 | |
52 |