Conditional formatting is not working for decimal data type and % format

[LakshmiSree]

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:

CTC Reliability Color = SWITCH(

TRUE()

,AVERAGE('Reliability Sheet'[CTC Reliability (%)]) >=0 && AVERAGE('Reliability Sheet'[CTC Reliability (%)]) <= 60, "#f44242"

,AVERAGE('Reliability Sheet'[CTC Reliability (%)]) >=61 && AVERAGE('Reliability Sheet'[CTC Reliability (%)]) <= 80, "#f4f142"

,AVERAGE('Reliability Sheet'[CTC Reliability (%)]) >=81 && AVERAGE('Reliability Sheet'[CTC Reliability (%)]) <= 100, "#5ff442",

"#f44242"

)

[az38]

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

LinkedIn

[LakshmiSree]

What I observed is, If I apply for one column its working fine. If I apply for multiple columns its not working properly.

[az38]

@LakshmiSree 

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

[LakshmiSree]

That is not a measure. "CTC Reliability" is the column and applied the AVG on the table visual field.

[LakshmiSree]

FYR.

So the above one did not work and i used the above measure(in first post)

[az38]

@LakshmiSree 

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

[LakshmiSree]

PFB. I believe now you can understand.

Table Visual.

Conditional Formatting.

[az38]

@LakshmiSree 

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