Forum Discussion
Conditional formatting is not working for decimal data type and % format
Hi LakshmiSree
first, I see a hole in your statement.
values between 60 and 61 and values between 80 and 81 will not be affected by conditional formatting rules
second, how do you get a column "Average ofCTC Reliability (%)" on screenshot? is it a measure (if yes, show a formula) or just aggregation in visual?
do not hesitate to give a kudo to useful posts and mark solutions as solution
FYR.
So the above one did not work and i used the above measure(in first post)
It's not completely understandable for me.
I see in the Conditional formatting dialog window you are trying to apply Average Summarization to "Average field". It looks like you get here average of average.
I dont know all your data model, but it seems like there is some inconsistance in the formulas
anyway, calculation AVERAGE can easily be different with AVG in visual. it because of row-context.
try to add new measure
CheckMeasure = AVERAGE('Reliability Sheet'[CTC Reliability (%)])and add it as column to visual to check
do not hesitate to give a kudo to useful posts and mark solutions as solution
PFB. I believe now you can understand.
Table Visual.
Conditional Formatting.
it doest clear anything without source data. sorry, screenshots only display the high level of report
do not hesitate to give a kudo to useful posts and mark solutions as solution