Forum Discussion

BSM1985's avatar
BSM1985
Helper IV
5 years ago
Solved

Decomposition Conditional Formatting

Hi Team, I have decomposition tree with 3 levels as shown below. Requirement: In this hierarchy, I would need: 1. All 'Yes' nodes in Blue color 2. Level A node 'No' should be in Black 3. Level B...
  • MFelix's avatar
    5 years ago

    Hi BSM1985 ,

     

    Try to add the following custom measure:

     

    Measure = SWITCH(
                       TRUE();
                       SELECTEDVALUE(Testing[A]) = "NO";"Black";
                       SELECTEDVALUE(Testing[B]) = "NO";"#FFC200";
                       SELECTEDVALUE(Testing[C]) = "NO";"Grey"
                     )

     

     

    You can also change the Black and Grey to other custom colour codes just remember to place the # before the code.

     

    Check PBIX file attach.