Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I am trying to apply conditional formatting for value "Yield". However, I am struggling to understand what rule to apply to meet my request. I want the value under Yield be green if the value is equals or greater than the value in STD yield column. Every raw is a different product , so I cannot use regular rules like "if yield is > 50" because each product has it own standard. Thank you. Any help is appreciated!
Product | Yield | Standard Yield |
A | 70 | 61.5 |
B | 51.5 | 52 |
C | 75 | 70 |
Solved! Go to Solution.
You then need to create a measure where you use IF condition.
Use the measure here
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Hi @KK111,
Multiple rules for conditional formatting can be configured. I think you can add a new rule for each of your requirements.
I hope this helps.
Hi Amine ,
Thank you. However, if I understand your colution correctly, it would not work in the case below:
I need it to be red because the yield is lower than standard yield. So, I cannot use a rule if yield value is > a certain number. What I am trying to do is to set up a rule when yield value is >= Standard Yield value than green, When value is , Standard Yield value than red. But I am struggling to undersntad how to set up such rule. Thank you
Yield | Standard Yield |
40% | 50% |
You then need to create a measure where you use IF condition.
Use the measure here
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Thank you so much, @aj1973 !! This made my day. I just followed you on all social media.
Do you know if it is possible to do the same but for the columns?
Thanks
hi @KK111
like this?
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |