Forum Discussion

Friso's avatar
Friso
Frequent Visitor
5 years ago
Solved

Conditional formatting row level

Hello,     The conditional formatting is normally based on the collumn. When I hav made a Matrix (for example MONTHS in de Collumns and categories (ladies, gentleman and kids) on the rows with de d...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Friso ,

     

    According to my understanding, you want to set gradient color sperately for negative and positive number, right?

    You could use the following formula to create a measure and apply it to conditional formatting.

     

    Measure =
IF (
    MAX ( 'Table'[Turnover] ) <= -0.15,
    "#8B0000",
    IF (
        MAX ( 'Table'[Turnover] ) > -0.15
            && MAX ( 'Table'[Turnover] ) <= -0.1,
        "#FF0000",
        IF (
            MAX ( 'Table'[Turnover] ) > -0.1
                && MAX ( 'Table'[Turnover] ) <= 0,
            "#F08080",
            IF (
                MAX ( 'Table'[Turnover] ) > 0
                    && MAX ( 'Table'[Turnover] ) <= 0.05,
                "#ADFF2F",
                IF (
                    MAX ( 'Table'[Turnover] ) > 0.05
                        && MAX ( 'Table'[Turnover] ) <= 0.1,
                    "#32CD32",
                    "#006400"
                )
            )
        )
    )
)

     

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

     

    Best Regards,
    Eyelyn Qin

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Friso ,

 

According to my understanding, you want to set gradient color sperately for negative and positive number, right?

You could use the following formula to create a measure and apply it to conditional formatting.

 

Measure =
IF (
    MAX ( 'Table'[Turnover] ) <= -0.15,
    "#8B0000",
    IF (
        MAX ( 'Table'[Turnover] ) > -0.15
            && MAX ( 'Table'[Turnover] ) <= -0.1,
        "#FF0000",
        IF (
            MAX ( 'Table'[Turnover] ) > -0.1
                && MAX ( 'Table'[Turnover] ) <= 0,
            "#F08080",
            IF (
                MAX ( 'Table'[Turnover] ) > 0
                    && MAX ( 'Table'[Turnover] ) <= 0.05,
                "#ADFF2F",
                IF (
                    MAX ( 'Table'[Turnover] ) > 0.05
                        && MAX ( 'Table'[Turnover] ) <= 0.1,
                    "#32CD32",
                    "#006400"
                )
            )
        )
    )
)

 

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

 

Best Regards,
Eyelyn Qin