Conditional formatting with different values

[WJ876400]

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

[amitchandak · Accepted solution]

@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/...
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pan...

[WJ876400]

thanks for your help I have solved it

[WJ876400]

thank you for the quick response, I am using a clustered column chart and the colour fornmatting is going on the Y-axis

I then went to the column colour and added the conditional formatting like below but it hasnt changed the colour of the bars