Forum Discussion

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

Need Help

MFelix

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.

Sample.pbix30 KB

MFelix

Super User

3 years ago

Hi eli9879 ,

Not sure if I understand what you mean by "Names" columns with the colors in the "Color" columns respectively.

Try to create the following measure:

Color Coding = SWITCH(TRUE(),
                    ISINSCOPE('Table'[Name3]), SELECTEDVALUE('Table'[Color3]),
                    ISINSCOPE('Table'[Name2]), SELECTEDVALUE('Table'[Color2]),
                    ISINSCOPE('Table'[Name1]), SELECTEDVALUE('Table'[Color1]))

Be carefull with the order of the columns since the switch function stops at the first result: