Conditional colour formating in a Mekko chart

[#1]

Dear all,

I have a mekko chart, which has a dimension called Hiherarchy2. Hierarchy2 is a subgroup of Hierarchy1.

How can I have the same colour for all Hierarchy2 belonging to the same Hierarchy1?

Attached is a dummy app.

Thank you in advance for your help!

Regards

[Gysbert_Wassenaar · Accepted solution]

Yes, use for example something like =color(FieldIndex('Hierarchy1' ,Hierarchy1)) as background color expression. If you have a lot of values in Hierarchy1 (you do) you may want to consider creating a table in the script to assign colors to the Hierarchy1 values. See this blog post for more information: Colors in charts

[#3]

Thank you for the suggestion. Indeed color(fieldindiex ... works magically! But i'll need to create a separate table as there are so many value.

Thank you!