AnsweredAssumed Answered

Pentaho report designer Bar chart serier color expression

Question asked by Prateek Bhatt on May 15, 2019

Hello Folks,

 

Need to write an expression for Series-colors for bar chart in report designer using 7.1 version, As there is static colors.

I'm using multiple if condition to achieve these but it is only works for 1st if condition not for other.

 

=IF([STAGE]=6;"#373EB2";IF([STAGE]=7;"#845788";IF([STAGE]=5;"#32B8D7";IF([STAGE]=4;"#71B057";IF([STAGE]=3;"#FFC647";IF([STAGE]=2;"#FF7332";IF([STAGE]=1;"#BF4442";"")))))))

 

It's working if we using data labels and apply text color expression but not works in bar chart series color expression.

 

Let me know if anyone has come across this issue and if you found any solution to achieve this. 

Thanks,

Prateek

Outcomes