Mekko chart / Colorize dimensions

[#1]

Hi everyone,

I do have a problem to set the color I want for my dimension in a Mekko Chart.

Let's resume my situation :

• one dimension : Category
• two expressions :
  • Sum(sales_count)
  • Sum(turnover)

For each category, i have three additionals datas : "Red color", "Green color" and "Blue color".

In every other charts, I'm using the background color of the first expression with the RGB() function to set the color of my category dimension. However, I can't find this option in the Mekko chart.

Did anyone already face this problem ?

Regards,

Damien

[#2 · Accepted solution]

Ok, i find how to do it : you have to use the rgb() function in the background color expression of both of the expressions used in the mekko chart ! (in my case : sum(sales_count), sum(turnover))