FX Color on stacked bar

[Lewdis_]

I have the following structure with three levels of data. I would like to keep the color of the sub group and product to be based on product group.

So for example Road Bikes on the sub level should be blue because its part of Bikes.

When I do a stacked chart with one line and legend I cant pick FX as an option. Is there another way?

[danextian]

Hi @Lewdis_ 

When you use legends either by using a column or by adding more than one measures, the option to use conditional formatting is disabled. Unfortunately, there is no way to automatically set the colors based on some criteria other than to manually set them.