Forum Discussion
Color Formatting Table Entire row
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 |
|
|
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:-
4 Replies
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:-
Thank you. That worked.
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.
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:-
