Conditional Formatting for Single Cell

[iamumer2195]

Hi, I am looking for a bit of help with Conditional Formatting. 

We use data to assess performance of our clients and then format them on their performance with Colours. 

However, A single case has appeared which meets the criteria to be coloured red but it is not really that. Is there a way to remove conditional formatting from a single cell while keeping everything else exactly how it is? I have tried excluding and removing the conditional formatting but it affects the whole data. 

Appreciate your help in advance. 

Thank you

[selimovd]

Hey @iamumer2195 ,

you can only apply conditional formatting to a whole column or not at all.

But you can change the behavior of this special case with a measure:

https://docs.microsoft.com/power-bi/create-reports/desktop-conditional-table-formatting#color-based-...

If you tell us more details we can help you to look for a solution. With different conditions you can adapt to many cases.

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards
Denis

Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovic