Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Conditional formatting based on different values

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 GoalRATELINE18:0019:00
50062LIN0101
1500186LIN0102
506LIN0103

 

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

1 ACCEPTED SOLUTION
v-cherch-msft
Microsoft Employee
Microsoft Employee

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)

1.png

Regards,

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-cherch-msft
Microsoft Employee
Microsoft Employee

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)

1.png

Regards,

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.