Conditional formatting based on a comparison of two numbers

[LLuet]

Hello everyone,

I have a question about Conditional Formatting and would really appreciate if someone could help me.

Initial situation:
I have a matrix with three columns:
1. event type
2. total number of events (of the type) that have already taken place
3. total number of events (of the type) that should be reached

Question: Is there a way to color-code the actual numbers, for example red if they do not yet meet the target numbers and green if the targeted total number has already been reached ?

Thanks a lot 🙂

[LLuet]

First of all, thanks for the quick answers, but the correct solution was probably not there yet.

I understand how normal conditional formatting works, but in my case I can't specify a threshold. To clarify the problem, here is a short example:

Event type A has taken place 23 times, but is supposed to take place 39 times. Event type B has taken place 15 times, although only 8 were planned.

Since the threshold value is different, I cannot specify a certain number from which a condition was met or not met. The numbers for each event type must be compared individually.

[VahidDM · Accepted solution]

@LLuet 
Try to add a measure to find the meet target status and then use that to set up the conditional formatting.

measure would be something like this:

measure=
Var _Variance = if([type] = A, [No. taken place]-39,[No. taken place]-8)
\\to find the variance between the actual vs forecast
return
if(_Variance>=0,True(),False()
\\ if _variance equal or bigger that 0, it means target has been met

Did I answer your question? Mark my post as a solution!

Appreciate your Kudos  !!

[VahidDM]

Hi @LLuet 

Please see this links:

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting

https://community.powerbi.com/t5/Community-Blog/Conditional-Formatting-in-Power-BI-Tables/ba-p/42799...

Did I answer your question? Mark my post as a solution!

Appreciate your Kudos  !!

[ziyabikram96]

you can use conditional formating background color upon threshold