best way to change colour on Decomposition tree depending on field value

[kelly1]

Hi,  i have a decomposition tree displaying an org chart with department > team > title > Name.

What would be the best way to change the display colour of the Name field based on other values held in the data table?  for example if Name is a remote worker then display the Name text in pink?  thanks

[MFelix · Accepted solution]

Hi @kelly1 ,

Have you tried using a condittional formatting measure?

[kelly1]

Perfect!  worked well.

Is there a way to add in more than one conditional formatting rule for different data field values?

[MFelix]

Hi @kelly1 ,

If you do your metric for the condittional formatting based on a ISINSCOPE or ISFILTERED in a SWITCH or an IF function then you can have the different levels.