Adding different Colours for different Row headers in Matrix in Power BI.

Hi srinivas_fabric ,

To add different colors for different row headers in a Power BI matrix, you can create a separate color mapping table and use that for conditional formatting. For example, create a table named ProductColors with the following structure:

In your main data model, if you have a table with a Product column, you can either relate it to ProductColors or just use a lookup in your DAX. Create a measure to retrieve the color for each product like this:

RowHeaderColor = 
LOOKUPVALUE(
    ProductColors[Color Code],
    ProductColors[Product],
    SELECTEDVALUE(YourMainTable[Product])
)

Then, in the matrix visual, instead of placing Product in the Rows section, place it in Values so you can apply conditional formatting. Use the RowHeaderColor measure for background color formatting by choosing "Format by field value" and selecting the measure. Power BI doesn't support directly coloring row headers, so this method fakes the header look by treating the label as a value and styling it accordingly.

Best regards,

srinivas_fabric  If you are limited in creating a new table, you can create a measure as shown below and use it for conditional formatting.

RowColor =
SWITCH(
[RowCategory],
"Category A", "#FF0000", // Red
"Category B", "#00FF00", // Green
"Category C", "#0000FF", // Blue
"#000000" // Default Black
)

You can explore custom visuals from the marketplace like:

• TableSorter or Matrix by MAQ Software
• Acterys Matrix Light

Some of these visuals offer more flexible formatting, including row header styling.