Remove Blanks on RLS

[kamalbandam]

Hi, 
I have a table of different categories like A,B,C,D where I want to show only A categories to Y and Z people, B to X and Y & C to X and Y.So, I have used RLS for this. It is working perfect. But If I want to show Category D only to the person W then remaining values will become blanks in the visuals for the person D. 

Is there anyway to avoid those blanks ?
Any help would be grateful.

Thanks,
Kamal

[Anonymous]

Hi @kamalbandam,

If you mean the visual that display records has been filtered by RLS filter and show the blank contains, it is impossible to avoid these blank. (power bi does not contain any feature to do modify on visuals visible property)
Perhaps you can add some dummy data or notice data to your tables and add a condition in your RLS filter to show them if they are no records match with the current user role. 

Regards,

Xiaoxin Sheng

[amitchandak]

@kamalbandam , something like this

if(USERPRINCIPALNAME() ="XYZ",[measure1],[measure2])

or

if(USERPRINCIPALNAME() ="XYZ",[measure1],blank())

or refer

https://community.powerbi.com/t5/MBAS-Gallery/Microsoft-Power-BI-Unleash-row-level-security-patterns...