Desktop

[Route11]

Hi experts

Is it possible to conditional format row headers or each row different colours within a standard table with in power bi.

[stretcharm · Accepted solution]

Rows can be coloured with the std conditional formatting, but you have to format each of the columns.

I usually have a colour field that can then be referenced in the Conditional Formatting format by field value.

e.g. You can use names or colour numbers

MaxValue1Col = SWITCH( max(Table1[Column1]), 1,"Green",2,"Red", "LightBlue")

Headers not with a std table. I think they are working on dynamic format expression that could help in future versions.

However you can fake it with 2 tables.

Edit Data to add a new table of the headers. You can the make a table from these and conditional format them

Make the header font the same colour as the background and overlay the header table above the other table.

[stretcharm · Accepted solution]

Rows can be coloured with the std conditional formatting, but you have to format each of the columns.

I usually have a colour field that can then be referenced in the Conditional Formatting format by field value.

e.g. You can use names or colour numbers

MaxValue1Col = SWITCH( max(Table1[Column1]), 1,"Green",2,"Red", "LightBlue")

Headers not with a std table. I think they are working on dynamic format expression that could help in future versions.

However you can fake it with 2 tables.

Edit Data to add a new table of the headers. You can the make a table from these and conditional format them

Make the header font the same colour as the background and overlay the header table above the other table.

[Route11]

Thanks for the excellent feedback much appreciated