Forum Discussion

dhrupal_shah's avatar
dhrupal_shah
Helper I
1 year ago
Solved

Conditional formatting not applied

Dear All,   created matrix visual from sql data which contain more than 20 column. i want to conditional fomatting on column name based. please refer my below code  and screen shot. as per conditio...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi dhrupal_shah ,

     

    You can try the following measure.

     

    Measure = 
VAR _sum = SUM('Production'[QtyRecv])
RETURN
SWITCH(
TRUE(),
TRIM(MAX('Production'[ComponentName])) = "CTL 1" && _sum > 50 , "#008000", // Green
TRIM(MAX('Production'[ComponentName])) = "CTL 1" && _sum >=35 && _sum <= 50, "#000a00", // Black
TRIM(MAX('Production'[ComponentName])) = "CTL 1" && _sum > 0 && _sum < 35, "#FF0000" //Red
)

     

     

    Also, depending on whether you want all columns to have conditional formatting added to them? If so, just remove the condition “TRIM(MAX(‘Production’[ComponentName])) = ‘CTL 1’”

     

    More detailed information can be found in the attachment.

     

    Best Regards,

    Clara Gong

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.

dhrupal_shah's avatar
dhrupal_shah
Helper I
1 year ago

thanks for your solution. 

not get result as expected. even 48.17 it show green.

 

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi dhrupal_shah ,

 

Can you share sample data in table format? Or a sample pbix after removing sensitive data. We can better understand the problem and help you.

 

Best Regards,

Clara Gong

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.