Forum Discussion
How to display/hide visual(s) based on user login?
Hello,
we are maintaining a table where we do the mapping of which user sees which visual. We need to check and hide visuals which are not there in the list for particular user.
For Eg.
| UserNM | PageNM | VisualNM |
| User1 | Page1 | Visual1 |
| User1 | Page1 | Visual2 |
| User1 | Page2 | ViIsual3 |
| User2 | Page1 | Visual2 |
| User2 | Page2 | Visual3 |
| User2 | Page2 | Visual4 |
This means, when user1 logins, he/she will be able to see Visual1 & Visual2 on Page1 whereas user2 will see only Visual2 on Page1 and so on .
Is this possible?
2 Replies
v-zhangtiCommunity Support
Hi, Anonymous
You can try using RLS to achieve your results. Please refer to the following document, hope it can help you.
https://docs.microsoft.com/en-us/power-bi/enterprise/service-admin-rls
https://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bi
https://community.powerbi.com/t5/Desktop/Dynamic-RLS/m-p/2523328#M895590
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-zhangti Thanks for the reply.
But we are not looking for RLS.
Using RLS, will make the data on the visual disappear but Actually we need to hide/show the entire visual.
As shown in the above example, User1 will see only 1 visual whereas User2 will see 2 visuals.