How to format row background color for a matrix?

[spagad6263]

Hi,

I have a matrix table, and would like to format the background color for the row which has Passed = "Y". I though Conditional Formatting might work, but can't figure it out. Any suggestions? Much appreciated!

[spagad6263]

That's great. Can I also hightlight the cell of "Y", which is under Passed column? Thanks

[PhilipTreacy · Accepted solution]

Hi @spagad6263 

Afraid not, you can only apply CF to the fields.

Regards

Phil

[PhilipTreacy]

Hi @spagad6263 

Download example PBIX file

Create a measure to set the background color like this

BG Color = IF (SELECTEDVALUE('DataTable'[Passed]) = "Y", "#0F0")

then you need to create a CF rule to apply the color.  This has to be done for each column in the matrix i.e. there is a separate rule for Count and %

Regards

Phil