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 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 

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.

2 Replies

  • 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.

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    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.