Forum Discussion
Change Decomposition tree color from multiple data columns
Hi, Can someone help me. I would like to allocate colors each breakdown level seperately. e.g. case1= Delivery done: Green -> PAC done: Green -> FAC not done: Yellow case2= Delivery done...
Hi,
Thank you for your detailed advice,
Does it manage to put colors each level respectively?
e.g.
Anything not done should be Yellow
Anyting done should be Green
Anything overdue should be Red
Hi Anonymous,
If you want to simply manage multiple fields status and setting colors, you can do unpivot these field to convert them to attribute and value, then you can check current value to assign color based on different status.
Unpivot columns - Power Query | Microsoft Learn
Regareds,
Xiaoxin Sheng