Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Solved! Go to 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,
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,
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
73 | |
72 | |
39 | |
31 | |
26 |
User | Count |
---|---|
97 | |
87 | |
43 | |
40 | |
35 |