Forum Discussion

saud968's avatar
saud968
Memorable Member
2 years ago
Solved

Conditional Formatting in matrix visual

Conditional formatting for an average of % in the matrix visual is not working... 0-4% should be green 5-10% in yellow and 11% above in red. You can review the screenshot below Abandon %...
Need Help
Show and Tell
Tips and Tricks
  • saud968's avatar
    saud968
    2 years ago

    Never Mind I was able to fix it, I changed the value a decimal number and found that in the rules i should use 0.04 and further so once it was fixed I changed it back % and it is working fine. Thank you for all your help

saud968's avatar
saud968
Memorable Member
2 years ago

This is the Google Drive link, I have copied the table on Excel and shared the Excel file - Please put the request for access - 

https://docs.google.com/spreadsheets/d/1QSRgpaE4NWsfASDQfBnSAc_YEMhIdKYZ/edit?usp=drivesdk&ouid=109378584867630822700&rtpof=true&sd=true


Total_Chat_Count = IF('support__cw_ops_manage_case_merge_temp'[Total_Chat_Count2] = "Chat", 1,0)
Total_Chat_Count2 = IF('support__cw_ops_manage_case_merge_temp'[CHAT_FLAG] = 1, "Chat", "Non-Chat")
Abandon % = IF(support__cw_ops_manage_case_merge_temp[ABANDONED_CHAT_FLAG] = 0, 0, support__cw_ops_manage_case_merge_temp[Total_Chat_Count] / support__cw_ops_manage_case_merge_temp[ABANDONED_CHAT_FLAG])
These are the measures for you that i used
Ahmedx's avatar
Ahmedx
Super User
2 years ago

I need a pbix file

  • saud968's avatar
    saud968
    Memorable Member
    2 years ago

    Never Mind I was able to fix it, I changed the value a decimal number and found that in the rules i should use 0.04 and further so once it was fixed I changed it back % and it is working fine. Thank you for all your help