cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
LLuet
New Member

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 🙂

 

1 ACCEPTED SOLUTION
VahidDM
Community Champion
Community Champion

@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_0-1630589112216.png !!

View solution in original post

4 REPLIES 4
LLuet
New Member

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
Community Champion
Community Champion

@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_0-1630589112216.png !!

View solution in original post

VahidDM
Community Champion
Community Champion

ziyabikram96
Helper V
Helper V

you can use conditional formating background color upon threshold

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.