Conditional formatting not available for my desktop v2018. I have a task to highlight the background

[sanjay009]

Need Help soon.

Conditional formatting not available for my Power bi desktop v march 2018. I have a task to highlight the background with red if failed status and green is status is Success. Do we have any fucntion or code that solve my task?

[v-xicai · Accepted solution]

Hi @sanjay009 ,

Recommend you upgrade the Power BI Desktop to the latest version 2.81.5831.821 .Then you create measure like DAX below, choose Background color under Conditional Formatting for your goal field, format by "Field value" based on [Conditional Measure] .   See more: Use conditional formatting in tables.

Conditional Measure = IF(MAX(Sales[status])="failed", "Red", "Green")

Result:

Best Regards,

Amy 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[sanjay009]

I am waiting for my company to upgrade the Powerbi to newer version. so far we have delay. meantime i am trying to resolve with the march 2018 Power bi desktop version. I can see conditional formatting only for number fields.

[parry2k]

@sanjay009 seems like you are using a very old version and not sure if conditional formatting was available than, you should upgrade it to the most recent version to take advantage of all the new and updated features.

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!