Forum Discussion
Conditional formatying on a row
Is it possible to conditional format row headers or each row different colours within a standard table with in power bi.
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.
2 Replies
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.