Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. 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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
96 | |
69 | |
45 | |
40 | |
30 |
User | Count |
---|---|
155 | |
96 | |
60 | |
42 | |
41 |