Forum Discussion

Lewdis_'s avatar
Lewdis_
Frequent Visitor
1 year ago
Solved

FX Color on stacked bar

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?

 

 

 

 

 

 

Need Help
  • danextian's avatar
    danextian
    1 year ago

    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.

1 Reply

  • danextian's avatar
    danextian
    Super User
    1 year ago

    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.