Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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 |
|
|
Solved! Go to 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:-
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
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:-
https://www.w3schools.com/colors/colors_picker.asp
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
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:-
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
11 | |
9 | |
8 | |
8 | |
8 |
User | Count |
---|---|
13 | |
12 | |
11 | |
10 | |
9 |