Conditional formatting on just one value in rows

[Rob_Morris]

I have the above matrix in Power BI, and I have set conditional formatting on the Pass / Fail percentage - however I would only like this conditional formatting to apply to the "Pass" values and not the "Fail" values from the [KPI_Check] field. (Fail should have no conditional formatting applied to them).

Is there a way to do this within Power BI at all?

[Samarth_18]

Hi @Rob_Morris ,

Try to put if condition in your conditional formatting code like below:-

Conditional_formating_measure = if(max(table[job_kpi]) <> "fail",{your formatting code goes here})

Thanks,

Samarth

[Rob_Morris]

Thanks for the reply but I'm very new to Power BI.

How would I go about doing this / where in the system is the option to do this?

The only options I can see in Conditional Formatting are Gradient, Rules and Field Value.

[Samarth_18]

@Rob_Morris , Could you please share how you have added conditional formatting in the report?