Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Issue with Conditional Formatting in Matrix Visual

Hi Team, Hope you're all doing well. I was working on applying conditional formatting in the Matrix visual, where I have a column called "ppk" and I am applying the following criteria to ac...
Need Help
Show and Tell
Tips and Tricks
Deku's avatar
Deku
Super User
1 year ago

try 

PPK_Conditional_Color_heatmap = 
VAR Ppk_Value = AVERAGE('PPK'[ppk_vl]) // No COALESCE applied
VAR StdDev_Value = AVERAGE('PPK'[stddev_vl]) // No COALESCE applied
RETURN
SWITCH(
TRUE(),
ISBLANK(Ppk_Value) && ISBLANK(StdDev_Value), "#808080", // Grey for NULL Ppk & StdDev is Blank
ISBLANK(Ppk_Value) && StdDev_Value = 0, "#ADD8E6", // Light Blue for NULL Ppk & StdDev = 0
Ppk_Value >= 1.33, "#69b764", // Green
Ppk_Value >= 1.00 && Ppk_Value < 1.33, "#ffc156", // Yellow
Ppk_Value < 1.00, "#d82526" // Red
)
  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi Deku ,

    Thanks for your response,

    I tried but still its coming as previous dax results.

     

    If there are any other solutions, please help me with it.

     

    Thanks in advance!