I currently have a report produces a matrix, displayed per user group. (1 user group per page, with 35 user groups/pages)

I want to highlight the row in pink in this condition:


However, it is not showing any colour. Please help! (I am using PowerBI Report Builder... should be same as SSRS)

1 Answer 1


If you are formatting cells based on group totals and not a row value, you need to use an aggregate and indicate the correct row group scope. In this sample, "UserName" is the name of the row group scope on the Row Groups section of the Grouping pane

=IIf(Sum(Fields!CountFailures.Value, "UserName") >=1, "Pink", "White")



Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.