Forum Discussion
Conditional formatting with different values
Hi
I have a table that has a students unit and then their grade. The level can be UG pr PG and they both have different pass marks.
If the level is UG anything that is 39 or below should be red and anything that is 40 or above is green.
If the level is PG anything that is 49 and below should be red and anything that is 50 or above is green.
| Unit | Mark | Level | |
| Unit 1 | 49 | PG | Red |
| Unit 1 | 50 | PG | Green |
| Unit 1 | 67 | PG | Green |
| Unit 2 | 39 | UG | Red |
| Unit 2 | 50 | UG | Green |
| Unit 2 | 60 | UG | Green |
how do i put conditional formatting on to reflect the different levels and values
thanks for any help
WJ876400 , Create a measure like
Switch(True(),
max(Table[Level]) = " UG" && sum(Table[Mark]) <=39 , "Red" ,
max(Table[Level]) = " UG" && sum(Table[Mark]) > 39 , "Green" ,
max(Table[Level]) = " PG" && sum(Table[Mark]) <=49 , "Red" ,
max(Table[Level]) = " PG" && sum(Table[Mark]) > 49 , "Green" )
Use this in conditional formatting using the field value option
How to do conditional formatting by measure and apply it on pie?
https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/1682539
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pane-66e0afcb15f3
3 Replies
WJ876400 , Create a measure like
Switch(True(),
max(Table[Level]) = " UG" && sum(Table[Mark]) <=39 , "Red" ,
max(Table[Level]) = " UG" && sum(Table[Mark]) > 39 , "Green" ,
max(Table[Level]) = " PG" && sum(Table[Mark]) <=49 , "Red" ,
max(Table[Level]) = " PG" && sum(Table[Mark]) > 49 , "Green" )
Use this in conditional formatting using the field value option
How to do conditional formatting by measure and apply it on pie?
https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/1682539
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pane-66e0afcb15f3
