Forum Discussion

mundy727's avatar
mundy727
Frequent Visitor
2 years ago
Solved

Conditional Formatting in Matrix Visual - Custom Thresholds for Heat Mapping

Hi, im realtively new to the forums here so apologies if i dont have this posted in the correct location!   I am looking to build out a head map for something similar to the table below. Im attempt...
General Comment
Need Help
Show and Tell
  • NaveenGandhi's avatar
    NaveenGandhi
    2 years ago

    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!!!


mundy727's avatar
mundy727
Frequent Visitor
2 years ago

Hi NaveenGandhi sure thing. Sorry, i am unsure how to attach an excel file here - but here is an example below

 

Dataset exampleConditional formatting