Forum Discussion

spagad6263's avatar
spagad6263
Icon for Post Patron rankPost Patron
3 years ago
Solved

How to format row background color for a matrix?

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? Muc...
Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    3 years ago

    Hi spagad6263 

     

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

     

    Regards

     

    Phil

PhilipTreacy's avatar
PhilipTreacy
Icon for Super User rankSuper User
3 years ago

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