Conditionnal formatting based on segment and table value

[ArmellA]

HI, 

Beginner here. I have this model, and want a conditionnal formatting in a matrix that looks like this. 

So depending on the "profile" value in the segment, I want the conditionnal formatting to change depending on the value of the corresponding mandatory and validity in Dim_Course. RED = undone (mandatory course) or expired (validity in days). 

Any clue ?  I'm lost.. 

Thanks 

[v-zhangti · Accepted solution]

Hi, @ArmellA 

You can try the following methods.

Measure = 
IF (
    MAX ( Dim_Profile[Mandatory] ) = "yes"
        && DATEDIFF ( SELECTEDVALUE ( Fact_Completion[DateCompleted] ), TODAY (), DAY ) > 365,
    "Red"
)

Set Measure to the background color of the table font.

Is this the output you expect?

Best Regards,

Community Support Team _Charlotte

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

[amitchandak]

@ArmellA , Not very clear but measure based conditional formatting can help

How to do conditional formatting by measure and apply it on pie? : https://youtu.be/RqBb5eBf_I4

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.