Forum Discussion
Conditional formatting is not working for decimal data type and % format
we are importing the data from excel with few calculated columns like Reliability, Margin Confidence, Quality and Revenue.
Built the table visual based on those columns and choose AVG aggregation on the field values and trying the conditional formatting if value >= 0 and value <=60 then red, If values >= 61 and value <= 80 then yellow, if values >=81 and value <= 100 then green but not working the colors for exact values. it is taking the green value for yellow conditions.
PFB. like this its happening for other columns also
I even tried below measure with sample color codes also but not worked:
8 Replies
- az38
Community Champion
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)
- az38
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
That is not a measure. "CTC Reliability" is the column and applied the AVG on the table visual field.
What I observed is, If I apply for one column its working fine. If I apply for multiple columns its not working properly.
- az38
well, I think the key is not in conditional formatting. it's about correct average calculate. you need to define how to you want to calculate it. what filter should be applied to statement and so on. next, check your formula and real data. then, conditional formatting should work ok
do not hesitate to give a kudo to useful posts and mark solutions as solution
