Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have an anonymized survey dataset and I want to present the results, with the use of slicers/visuals to allow the breakdown of the responses based on the responders age, gender and department.
I want to restrict the user for using those slicers/visuals in order to identify who is the person that gave a specific answer (ie. if I select F, 26-35, Sales; only one responder exists, so the enduser can identify the responder and see exactly what that person answered).
Is there a way to have all slicers visible and active, but when I use the Gender slicer, then I'm not allowed to use any of the other slicers?
Hi @AP2 ,
About restricting users, you might consider setting row-level security. Row-level security (RLS) with Power BI can be used to restrict data access for given users. Filters restrict data access at the row level, and you can define filters within roles. In the Power BI service, members of a workspace have access to datasets in the workspace. RLS doesn't restrict this data access.
What Do You Need to Implement Dynamic Row-Level Security in Power BI? - RADACAD
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
the RLS doesn't seem to be the ideal solution here.
The task is not to limit the user's access to data, but limit the user's ability to interact between the slicers and the visuals, in a more complex way, that just one slicer not interacting with the other sclicer.
Hi,
The only way is to use SELECTEDVALUE function but i don't think it will work or it will be very complicated.
A simpler way would be to create elements similar to slicer with selection and bookmark pane.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
79 | |
73 | |
56 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |