topic Color Matrix row header with different colors in DAX Commands and Tips

Color Matrix row header with different colors

NG1407 — Mon, 29 Sep 2025 14:33:18 GMT

I have a matrix where there is Row header and when we expand row header we get subheader. I want to color only Row header that too different colors for each row value.

Also these color should be only for Row header cells and not all row values.

How can I do it.

Row Header	Sub header	Value
Orange
Green
Purple

Re: Color Matrix row header with different colors

MasonMA — Mon, 29 Sep 2025 14:43:46 GMT

If this is Row Header conditional formatting, consider voting it as an idea https://community.fabric.microsoft.com/t5/Fabric-Ideas/Conditional-Formatting-of-Row-Headers-in-Matrix/idi-p/4509809

Re: Color Matrix row header with different colors

Nabha-Ahmed — Sat, 04 Oct 2025 14:04:28 GMT

Hi NG1407

Create a calculated column in your dimension (replace Table and RowHeader with your names):

RowLabel_WithEmoji =
SWITCH(
TRUE(),
'Table'[RowHeader] = "Orange", "🟧 " & 'Table'[RowHeader],
'Table'[RowHeader] = "Green", "🟩 " & 'Table'[RowHeader],
'Table'[RowHeader] = "Purple", "🟪 " & 'Table'[RowHeader],
'Table'[RowHeader]
)

-Use RowLabel_WithEmoji as the matrix row field. This visually highlights only the row header cells.

Thanks

Re: Color Matrix row header with different colors

NG1407 — Mon, 06 Oct 2025 07:49:30 GMT

It doesn't work. it just add colorname or the color icon infront of row header instead of coloring the background.

Re: Color Matrix row header with different colors

Praful_Potphode — Tue, 07 Oct 2025 02:47:37 GMT

As suggested by MASON,it is not possible to do conditional formatting for matrix visuals.if you want conditional formatting for now, then use table visual