Color coding Sales Quotas in table

[jdubs]

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

[jdubs]

Thank you. 

[some_bih · Accepted solution]

Hi @jdubs I created 3 measures, 2 are simple sum

MeasureSales = SUM(Sheet23[Sales])

MeasureTarget = sum(Sheet23[Target])

and third is 

%KPI =

    DIVIDE([MeasureSales],[MeasureTarget])

Adjust Sheet23 to your Table name. Rules for conditional formating shown on picture below. I hope this help.

[jdubs]

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. 

[some_bih]

Hi @jdubs check official tutorial https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting  I hope this help