Forum Discussion
Solved
Color coding Sales Quotas in table
Are there any good tutorials out there or can someone explain how to use conditional formatting to color code a column of Sales history against a Quota column? I tried using Gradient but am getting varied results.
I would like the Sales value to turn green when a person is within say 85% of their goal. Yellow when it is between 40-75. And red if it is below 40% of the target value.
| Sales | Target |
| $25,000 (Yellow) | $50,000 |
| $95,000 (Green) | $100,000 |
| $10,000 (Red) | $75,000 |
4 Replies
Thank you.
Hi jdubs check official tutorial https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting I hope this help
Thanks. I think I need to add a measure that is the percentage of the target value and then color code the Sales column using this value.
