Reply
Member
Posts: 342
Registered: ‎05-10-2018
Accepted Solution

Conditional formatying on a row

Hi experts

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

Accepted Solutions
Senior Member
Posts: 326
Registered: ‎07-05-2017

Re: Conditional formatying on a row

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.

 

table1.PNG

 

 

View solution in original post


All Replies
Senior Member
Posts: 326
Registered: ‎07-05-2017

Re: Conditional formatying on a row

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.

 

table1.PNG

 

 

Highlighted
Member
Posts: 342
Registered: ‎05-10-2018

Re: Conditional formatying on a row

Thanks for the excellent feedback much appreciated