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? Much appreciated!

 

 

Need Help

3 Replies

  • 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

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

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

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

      Hi spagad6263 

       

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

       

      Regards

       

      Phil