Conditional formatting based on different values

[Anonymous]

Hello guys! Let's see if you can help me.
I'm trying to do a conditional formatting based on specific values.

We have our production lines, and each line has to produce an amount per hour. At the end of the day, it must achieve the daily goal.

The actual operation is, I input my daily goal in a collumn, and it gives me what my rate per hour is, and each production line has its own rate. My conditional formatting is based on my rate per hour.

Here's an example:

Daily Goal =500 unit

Work Hours = 8,06

Rate = (500/8,06): 62

Daily Goal	RATE	LINE	18:00	19:00
500	62	LIN0101
1500	186	LIN0102
50	6	LIN0103

If the value is below my rate it would be red, if it is equal or above, it would be green.

How can I use a value in one cell to consider as my reference on conditional formatting? Use one collumn as reference, and it can be changed every day.

The way I saw here, at conditional formatting, I'd have to input the value manually, but what I want is to give my daily goal, and it gives me my rate per hour.

*Couldn'd upload a photo here.

Thanks in advance for your attention

Edgar Barbosa

[v-cherch-msft · Accepted solution]

Hi @Anonymous 

You may try to create a rule measure like below.Then use it in conditional formatting.

Rule = IF(SUM(Table2[18:00])>=SUM(Table2[RATE]),1,2)

Regards,

[tarunsingla]

Check this latest update:

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-june-2019-feature-summary/#conditionalForm...