Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hi together,
I am going to share the below (simplified) data with my colleagues.
Unfortunately I have to restrict the access, which means a few colleagues should be allowed to see the order quantity only, while others should see Amount EUR and Order Qty.
Is there a way to define a role or something similar so that those people with "order quantity access" only, will not see any Amount EUR values in such visual?
@Orstenpowers , You can make it blank
like
if( userprincipalname() in {"abc@bac.com" , "b@abc.com"} , [Measure], blank())
Sorry, for the following (stupid) question...where to write this formula?
And for testing, I replace "abc@bac.com" with my own mail address?
@amitchandak
I made another screenshot to illustrate the initial situation.
These are the data that I am working with.
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!