Forum Discussion

suni_v's avatar
suni_v
Regular Visitor
4 years ago

Decomposition Tree data bar conditional formatting

Hi Team, I have decomposition tree with 3 levels as shown below. In this hierarchy, I would need: If one of the nodes unders product is yellow, all of its parent nodes should be yellow in color. C...
Arul's avatar
Arul
Super User
4 years ago

Hi suni_v ,

I tried this by creating a measure and use it in conditional formatting,

CF = 
SWITCH(TRUE(),
SELECTEDVALUE(financials[Year])=2014,"#FFC200",
SELECTEDVALUE(financials[Year])=2013,"Black")

 

Try and let me know if it works as per your expectation or not.

 

Thanks,

Arul