Forum Discussion

Rob_Morris's avatar
Rob_Morris
Icon for Helper I rankHelper I
4 years ago

Conditional formatting on just one value in rows

 

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?

Need Help

3 Replies

  • Samarth_18's avatar
    Samarth_18
    Icon for Community Champion rankCommunity Champion
    4 years ago

    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's avatar
      Rob_Morris
      Icon for Helper I rankHelper I
      4 years ago

      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's avatar
        Samarth_18
        Icon for Community Champion rankCommunity Champion
        4 years ago

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