Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
50 | |
27 | |
23 | |
13 | |
8 |
User | Count |
---|---|
73 | |
51 | |
45 | |
16 | |
12 |