Conditional Formatting based on Row Level Security

[coding7]

Hi all,

Is it possible based on RLS, create a conditional formatting in a certain value/measure?

For example, having the cost value/measure, and if I put the users in a role called Green, for example, these users will see the negative values ​​in green. If I put the users in a role called Red, these users will see negative values ​​in red.

I tried searching but didn't find much information, if someone can help me in achieving this, I would appreciate it very much.

[johnyip]

@coding7 , you need to setup a measure like the sample from @Anonymous, but also utilizing USERPRINCIPALNAME() and IF() to apply different colors as per different groups.

[Anonymous · Accepted solution]

Hi @coding7 ,

Please refer the attached .pbix file.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.