I have Sample data as below
Empid OverallRating Apraiseratinglastyr Apraiseratingcurrentyer
AAAAAA 3.5 3 4
BBBBBB 4 4 4
Output willbe as below
Empid Status OverallRating Apraiseratinglastyr Apraiseratingcurrentyer
AAAAAA 3.5 3 4
BBBBBB 4 4 4
Status is color coded based on OverallRating<5 Color is RED
Status color coded based on >Apraiseratinglastyr and lessthan orequal Appraisalratingcurrentyer color is Blue(this is sample scenario non )
I need the above output can you please help me on this.
Yes by mistake color got selected…for yello but logic is same…yellor or green some color we need to show may be my data doesnt have required creteria but conditions are as above
Hi @amruthdna2018, a response on this post has been tagged as “Solution”. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box. Also, we’ve recently launched the Enterprise DNA Forum User Experience Survey, please feel free to answer it and give your insights on how we can further improve the Support forum. Thanks!
After which i configured in Conditionalformatting and assign the rules to these number -1 and 1 and used in the rpeort.The report column is showing Red(-1) Grren(1) as per the logic.Now i wanted to use this ColorcodedValue as Slicer or filter is this possible.
To use it as a slicer or filter in the report you need to use as calculated column not measure. Also if you convert above DAX measure to calculated column then will not have the same dynamic as it doesn’t calculate on the fly. Still you can give a try and see how is the result.