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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
HenryJS
Post Prodigy
Post Prodigy

Matrix - Colour Formatting Row Headers

Hi all,

 

Is it possible to colour format rows in a matrix?

 

thanks

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @HenryJS ,

 

As shown below, there is no "Conditional Formatting" option for Rows or Columns in Matrix:

Eyelyn9_0-1637289265484.png

 

But you could apply Conditional Formatting to Values, and as @selimovd  mentioned, you need to create a measure or just based on the value itself:

Eyelyn9_1-1637289793586.pngEyelyn9_2-1637289917374.png

 

 

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Hi @HenryJS ,

 

As shown below, there is no "Conditional Formatting" option for Rows or Columns in Matrix:

Eyelyn9_0-1637289265484.png

 

But you could apply Conditional Formatting to Values, and as @selimovd  mentioned, you need to create a measure or just based on the value itself:

Eyelyn9_1-1637289793586.pngEyelyn9_2-1637289917374.png

 

 

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

selimovd
Super User
Super User

Hey @HenryJS ,

 

in general you can only color by a measure or a specific value with conditional formatting:

Conditional table formatting in Power BI Desktop - Power BI | Microsoft Docs

 

The best trick is to use a measure for the background color. Check the solution in this post:
powerbi - Power BI: How to conditionally format a row of a table in Power BI DAX - Stack Overflow

To really have the possibility to color a row, you should upvote the following idea:

Microsoft Idea  · Conditional Formatting - Whole Table Rows (powerbi.com)

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis
 

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors