Matrix Visual, Conditional Formatting, Row Values

[Anonymous]

I'm looking to do conditional formatting (colour coding) based on the values in each row in a matrix.

Is there a way to do that? See picture. Every row needs it's own conditional formatting based on the higest and lowest value in each row. This to see the difference between columns 1,2 and 3 colour coded with one look.

Thank you for help

[v-lionel-msft · Accepted solution]

Hi @Anonymous ,

You can do like this.

(Please refer to my .pbix file.)

1. Sum columns group by another column.

2. Unpivot the columns

3. Create measures.

Min_value = 
CALCULATE(
    MIN(Sales[Value]),
    ALLEXCEPT(
        Sales,
        Sales[Month]
    )
)

Max_value = 
CALCULATE(
    MAX(Sales[Value]),
    ALLEXCEPT( 
        Sales,
        Sales[Month]
    )
)

Color_code = 
IF(
    SELECTEDVALUE(Sales[Value]) = [Max_value],
    "Blue",
    IF(
        SELECTEDVALUE(Sales[Value]) = [Min_value],
        "Red"
    )
)

Best regards,
Lionel Chen

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

[parry2k]

@Anonymous you cannot conditionally format row but you can make a measure that returns the color code based on the business logic and then apply the same measure for each column in the matrix using conditional formatting and choosing field value option.

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

[Anonymous]

Hey!

Thanks for the answer. Not sure that helps in my case.