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
carlalima
New Member

Conditionally format the row header of a matrix chart

How do I conditionally format the row header of a matrix chart in Power BI?

I have a matrix chart where: In "Lines" I inserted the data from two columns of table 1. (Ex: Columns: A and B) In "Columns" I inserted another column from table 1 (Ex: Column C) and a column from table 2 pulling the months (Ex: Column D). In Values, insert the sum of two columns ( E and F ) from table 1. I want to format all the lines, both the header lines and the value lines so that whenever the word "total" appears, the background color changes.

I was able to do this in the value fields by inserting a measure in the "conditional formatting" option using this DAX formula:
"Format 1 = IF(CONTAINSSTRING(SELECTEDVALUE(TABLE1[COLUMN A]), "TOTAL"), "#CCCCCC", BLANK())"

But I'm not able to format the line headers this way. All the tutorials I see are related to column formatting, column headers and values...

 

1 REPLY 1
Greg_Deckler
Community Champion
Community Champion

@carlalima Not implemented to the best of my knowledge.

 



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

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.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

Top Solution Authors