Forum Discussion

giramswa's avatar
giramswa
Helper II
4 years ago
Solved

Conditional formatting(Font Color) of row values in Matrix Visual with different target for each row

Hi All,   I have a matrix visual with Rows and Values as below:     I have not used any columns here. [3 months], [6 months] and [12 months] are separate measures that are concatenat...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi giramswa ,

     

    Please create 3 measures seperately for [3 months],[6 months],[12 months]

    For 3 months color = SWITCH(MAX('Table'[Metric]),
"overage",IF( ABS([3 months])>14,"Red","Green"),
"Accuracy",IF( ABS([3 months])>20,"Red","Green"),
"Timeliness",IF([3 months]>0.85,"Green",IF([3 months]>0.1,"Yellow","Red")),
"Compliance",IF([3 months]>0.8,"Green","Red")
)

    ......

     

     

    Best Regards,
    Eyelyn Qin
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

giramswa's avatar
giramswa
Helper II
4 years ago

Anonymous - your solution was Bang on! It worked perfectly. Thank you so much for your help.