Color Formatting Table Entire row

[rwong1]

Hi,

I need to do conditional coloring based on the sales stage.  For example, final committee review and due diligence will be red, term sheet negotiation will be yellow, and collecting information will be green.  Presume the below is the table that's in Power Bi.  This is a table, not a matrix.  Also I need the entire row highlighted in those colors, not just the sales stage column.

Opportunity Name	Facility Size	Expected Close Date	Sales Stage
xxxx	$       6,000,000	3/31/2020	Contract Negotiation
xxxx	$       5,000,000	2/28/2020	Contract Negotiation
xxxx	$    20,000,000	3/31/2020	Due Diligence
xxxx	$    10,000,000	3/27/2020	Term Sheet Negotiation
xxxx	$    22,000,000	4/30/2020	Term Sheet Negotiation
xxxx	$       6,000,000	3/26/2020	Collecting Information
xxxx	$    20,000,000	3/31/2020	Collecting Information
xxxx	$    18,000,000	3/31/2020	Collecting Information
xxxx	$       4,000,000	3/31/2020	Collecting Information
xxxx	$    20,000,000	4/3/2020	Collecting Information
xxxx	$       3,000,000	4/23/2020	Collecting Information
xxxx	$       5,000,000	4/3/2020	Collecting Information
xxxx	$       5,000,000	4/10/2020	Collecting Information
TOTAL	$144,000,000

[rwong1]

Thank you.  That worked.

[rwong1]

Just a question, where can I find the color names that Power Bi allows?  I like red but I may want a lighter version of red.

[Samarth_18]

@rwong1 , As far as I know there is no color limitation. If you wanted to add any other color then replace color name with hexa color code.

You can pick color code from below website:-

https://www.w3schools.com/colors/colors_picker.asp

[Samarth_18 · Accepted solution]

Hi @rwong1 ,

Create a measure as below and use it conditional formating for all the columns.

_conditional_color = SWITCH(TRUE(),
MAX('Table'[Sales Stage]) = "Due Diligence","red",
MAX('Table'[Sales Stage]) = "Term Sheet Negotiation","Yellow",
MAX('Table'[Sales Stage]) = "Collecting Information","Green")

Refer a file below:-