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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Clara
Advocate II
Advocate II

Conditional formatting for "rows" in matrix visual?

I can conditionally format my "values" just fine, but I want the row headers to follow the same format. Is there any way to enable that in the matrix visual -- or is there a custom matrix visual which would let me do that?

 

oi.PNG

 

 

Edit: To be clear, this is what my matrix currently looks like. I've set a column with numbers for the ID level (i.e. '1' is level 1 and '1.1' is level 2, and so on) and used it to conditionally format my values (columns Valor and Média de AV). I would like the ID column to follow the same formatting as the rest.

matrix.png

5 REPLIES 5
Anonymous
Not applicable

If I understood this correctly, I got around it by creating a computed column -- let's call it "ColorPicker".

 

In my instance, my Matrix has 3 rows of data (and multiple columns), the rows and their respective headers are:

StatusA (row 1)

StatusB (row 2)

StatusC (row 3)

 

My colorpicker computed column (which is a Nested IF) basically indicates that in my source data:

IF I come across StatusA, assign colorpicker a value of 1

IF I come across StatusB, assign colorpicker a value of 2

IF I come across StatusC, assign colorpicker a value of 3


Afterward, I apply conditional formatting to the Values within the matrix via:

Format by Rules

Based on field (Min of ColorPicker)

Setup 3 rules:

If value is 1 (number) then Green

If value is 2 (number) then White

If value is 3 (number) then Yellow

 

Now each respective row of the Matrix has its own color.

Anonymous
Not applicable

I would need this too. 

I saw in September 2020 PBI version that one can determine a background color of a visual with a formula. The same option could be applied to "Row Header" background color, and then we would finally have Subtotal background for e.g. financial statements without 3rd party visuals. 

v-chuncz-msft
Community Support
Community Support

@Clara,

 

This is not supported. In the Format section of the Visualizations pane, you may select Style and Row headers.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anyone find a solve for this? I am looking to do the same.  Apply Conditional formating to a matrix visual "rows"

I need too. I think it isn't possible. Does someone know if exist an idea for this topic?

thx

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