Forum Discussion

pmadam's avatar
pmadam
Helper II
2 years ago

Conditional Formatiing help

Team,

 

I need help with having condional formating added in colors or icons for values when greater compared to previours year.

Eg /: countdata in values if its igreater than competitor previous year, it should give be green else red. 

 

Please help 

 

 

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi pmadam ，
    Here some steps that I want to share, you can check them if they suitable for your requirement.
    Here is my test data:

    Create a column

    Color = 
VAR _t = 'Table'[Domain]
RETURN
IF(
    ISNUMBER(
        LOOKUPVALUE(
            'Table'[TotalCount],
            'Table'[Domain],
            _t,
            'Table'[PriceDate],
            DATEADD('Table'[PriceDate], -1, YEAR)
        )
    ),
    IF(
        'Table'[TotalCount] >
        LOOKUPVALUE(
            'Table'[TotalCount],
            'Table'[Domain],
            _t,
            'Table'[PriceDate],
            DATEADD('Table'[PriceDate], -1, YEAR)
        ),
        "green",
        "red"
    ),
    "green" 
)

    Use the column as the filed value of conditional foramtting of the [TotalCount]

     

    Final output

    Best regards,

    Albert He

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

     

     

    • pmadam's avatar
      pmadam
      Helper II
      2 years ago

      I get error msg " multiple values was supplied where a single value was expected" . Is it because of duplicated data in it. Please help with resolution

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi pmadam ,
        According to your description, this error occurs when two values are compared to each other, and you need to give both sides of the equation unique values to compare. In the previous code, the applicable case was to create a calculated column instead of measure.

        Best regards,

        Albert He

         

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly