Forum Discussion

ArmellA's avatar
ArmellA
Frequent Visitor
4 years ago
Solved

Conditionnal formatting based on segment and table value

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 t...
Need Help
  • v-zhangti's avatar
    v-zhangti
    4 years ago

    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.

v-zhangti's avatar
v-zhangti
Community Support
4 years ago

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.