topic Re: Decomposition Tree data bar conditional formatting in DAX Commands and Tips

Decomposition Tree data bar conditional formatting

suni_v — Thu, 05 May 2022 14:42:01 GMT

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. Could someone please help on fulfilling this requirement.

Thanks,

Re: Decomposition Tree data bar conditional formatting

Arul — Fri, 06 May 2022 14:25:53 GMT

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

Re: Decomposition Tree data bar conditional formatting

Icey — Fri, 13 May 2022 08:57:09 GMT

Hi suni_v ,

Based on my test, I'm afraid this is not supported in Power BI.

To my understanding, if the decomposition tree is formatted as what you want, let's take an example:

When Product="Paseo", the bar of MonthNumer=6 should be yellow;

When Product="Velo", the bar of MonthNumer=6 should be purple;

Then how shoud the bar of MonthNumer show? Yellow or Purple?

Therefore, it may not supported.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.