Forum Discussion
Conditional formatting based on a comparison of two numbers
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
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 metDid I answer your question? Mark my post as a solution!
Appreciate your Kudos !!
4 Replies
ziyabikram96Helper V
you can use conditional formating background color upon threshold
- VahidDM
Super User
Hi LLuet
Please see this links:
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting
Did I answer your question? Mark my post as a solution!
Appreciate your Kudos !!
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
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 metDid I answer your question? Mark my post as a solution!
Appreciate your Kudos !!
