Multicolored in Combo chart

[#1]

Dear Community,

For the combo charts, i want to show the bar chart in multicolor, it works fine when there is only one expression as shown below:

But when i add another expression, multicolored selection is gone, the bars turn to similar color. Anyone can help?

I cannot fix the color to every dimension because there might be thousand dimensions in the document...

Thanks and best regards,

Chanel

[Gysbert_Wassenaar · Accepted solution]

As you noticed the option Multicolored works only if there is one expression. There is a workaround:

Click on the + sign in front of the expression, select Background Color and add an expression to calculate the color for the bar. If you have a small number of dimension values (up to 20) you could use color(fieldindex('MyDim1',MyDim1)). Replace MyDim1 with the name of the dimension you use in your chart.

[#3]

Hi Wassenaar,

Thanks so much for your prompt response, currently my dimension has less than 20 values, but it will grow to more than 20 in the future.

Somehow, I did try your solution, it changed the bar color to black. Am I doing any wrong step?

Thanks and best regards,

Chanel

[Gysbert_Wassenaar]

You forgot the last part: Replace MyDim1 with the name of the dimension you use in your chart.

[#5]

Awesome man! You are really Legend!

Thanks and best regards,

Chanel

[pandiarajan]

Dear Gysber,

              Thank  u for ur idea.its really working fine. suppose my dimensions any cyclic group how it will work ? any idea Mulicolor combo chart with cyclic group