Conditional Formatiing help

[pmadam]

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 

[Anonymous]

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]

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]

Hi @pmadam ,
Whether the problem has been solved. If there are other related issues you can continue to provide details below.

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

[Anonymous]

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