Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
spagad6263
Post Patron
Post Patron

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!

 

spagad6263_0-1668547029910.png

 

1 ACCEPTED SOLUTION

Hi @spagad6263 

 

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

 

Regards

 

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


View solution in original post

3 REPLIES 3
spagad6263
Post Patron
Post Patron

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

Hi @spagad6263 

 

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

 

Regards

 

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


PhilipTreacy
Super User
Super User

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 %

cfmat.png

 

cfmat2.png

 

Regards

 

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.