Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowGet inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.
Hello colleagues, I need to show or hide a visual, depending on the user who connects. In this case, as there would only be two users to whom the visual has to appear, I did not want to use RLS because I tried and I could not.
Someone comes up with how to show an object with some type filter:
if (_usu="abcd@outlook", shows object, does not show object) something that I can put to that object and show it only to that user?
I would appreciate any help, because I have been trying for several days before requesting your help.
Thanks and greetings
Solved! Go to Solution.
Hi @Syndicate_Admin ,
Please try:
1. Create a card visual and adjust its size to cover the object (Power Automate button):
2. Apply the measure to the card visual and turn off Category Label:
Measure = ""
3. Create a transparent measure and apply this to the card visual:
Transparent =
IF ( USERNAME()="abcd@outlook", "#FFFFFF00", "White" )
Final output:
Note: This method is not completely secure, so if the content you need to hide contains sensitive data, consider using RLS.
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Syndicate_Admin ,
Please try:
1. Create a card visual and adjust its size to cover the object (Power Automate button):
2. Apply the measure to the card visual and turn off Category Label:
Measure = ""
3. Create a transparent measure and apply this to the card visual:
Transparent =
IF ( USERNAME()="abcd@outlook", "#FFFFFF00", "White" )
Final output:
Note: This method is not completely secure, so if the content you need to hide contains sensitive data, consider using RLS.
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
83 | |
77 | |
40 | |
40 | |
35 |