Forum Discussion

LakshmiSree's avatar
LakshmiSree
Frequent Visitor
6 years ago

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...
Need Help
az38's avatar
az38
Community Champion
6 years ago

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's avatar
LakshmiSree
Frequent Visitor
6 years ago

PFB. I believe now you can understand.

Table Visual.

Conditional Formatting.

  • az38's avatar
    az38
    Community Champion
    6 years ago

    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