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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
dw700d
Post Patron
Post Patron

Change background color of one specific row in a Matrix

I have the following matrix below. I would like to add a background color  for all the numerical values in Outflow row.(the Proceeds column, Allocation column , Audit column and Cost column). Can anyone help me with this?

 

dw700d_1-1644188924923.png

 

 

2 REPLIES 2
TheoC
Super User
Super User

Hi @dw700d,

 

If you apply what @amitchandak has provided for values, you can apply something similar on text-based columns by applying a few more steps as provided in this article by Matt Allington, here: https://exceleratorbi.com.au/conditional-formatting-with-a-text-field-in-power-bi/

 

Cheers.

Theo

If I have posted a response that resolves your question, please accept it as a solution to formally close the post.

Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!

Want to connect?www.linkedin.com/in/theoconias

amitchandak
Super User
Super User

@dw700d , Change of row color(conditional formatting) is not supported. You also fo conditional formatting in the matrix for the row column.

You can only color values. You can color all columns on values. based on a conditional to create row color

 

You can create a color measure and use that in conditional formatting using field value option

 

if(FIRSTNONBLANK(date[date],blank())= today(),"green","red")

or

 

Colour =
SWITCH(TRUE(),
'Table'[Date] < TODAY(), "red",
'Table'[Date] = TODAY(), "orange",
"green")

 

How to do conditional formatting by measure and apply it on pie?: https://youtu.be/RqBb5eBf_I4

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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

Top Solution Authors