Forum Discussion
BSM1985
5 years agoHelper IV
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...
- 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.
Anonymous
4 years agoNot applicable
Hi MFelix,
Can you please share how the color of the parent data bars can also be changed as per a condition?