Forum Discussion
Conditional Formatting in Matrix Visual - Custom Thresholds for Heat Mapping
mundy727
Create these two measures and make the CF as the field value for conditional formatting.Count# = COUNT('Table'[Status])
CF =
Var Row_ = CALCULATE(min(Capacity[Capacity]),Capacity[Name]=SELECTEDVALUE('Table'[Name]))
RETURN SWITCH(TRUE(),[Count#]>Row_,"Red",[Count#]<Row_,"Green",[Count#]=Row_,"Yellow")If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!
Follow me on LinkedIn!!!
Hi mundy727 ,
CF is the rule of color display and it needs to be built into your capacity. As per your original screenshot, you need to use CF for the "Value" in Early,Advanced, At offer. That's the field you let into the matrix to create conditional formatting for "Value", and this rule is CF.
Hope it helps!
Best regards,
Community Support Team_ Scott Chang
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous thank you!
I've built the capacity table to show the capacity of the recruiter as follows below. In effort to simplify i thought to just have the total capacity # in this table. When i attempt to bring this field into the conditional formatting prompt 'what field should we base this on' i recieve a red box when selecting the total field from this table as shown below. Maybe i am missing a step here? Thank you again for all of your support!
mundy727
Create these two measures and make the CF as the field value for conditional formatting.Count# = COUNT('Table'[Status])
CF =
Var Row_ = CALCULATE(min(Capacity[Capacity]),Capacity[Name]=SELECTEDVALUE('Table'[Name]))
RETURN SWITCH(TRUE(),[Count#]>Row_,"Red",[Count#]<Row_,"Green",[Count#]=Row_,"Yellow")If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!
Follow me on LinkedIn!!!