How to apply color-measurement to a Matrix?

[jtj]

Hi I want to apply this color-measurement to my matrix. The goal is the change the color of the text inside the matrix based on my DAX measurement. 

My matrix looks like this:

 

My table contains these columns:

My measurement looks like this:

ColorColumn =

IF(

    MAX('matrix_data'[faktuel_vaerdi]) > MAX('matrix_data'[bedste_tal]) && MAX('matrix_data'[faktuel_vaerdi]) > MAX('matrix_data'[average_price]),

    "Green",

    IF(

        MAX('matrix_data'[faktuel_vaerdi]) > MAX('matrix_data'[average_price]),

        "Yellow",

        "Red"

    )

)

But when I apply it, it doesnt change color, it just create another column with the color written out in text. 

[jtj · Accepted solution]

I found the solution to be 

1. Choose Conditional formatting

2. Formattype = Field value 
3. Based on ColorColumn

[Anonymous]

Hi @jtj 

Congratulations!

Thank you for sharing, this will help other users in the forum who are confused about this issue.

Best Regards

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